{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Summary","READMEFIRST","Title","MAX.ALL.NON-SALARY DIRECTS","Scoping Checklist","LIBRP_PEF CLASSIFICATION SHEET","Roadway","Traffic Control","Hydraulics","Structures","Location Surveys","Geotechnical","Utilities--Coord & Design","Right of Way","PDEA","MISCELLANEOUS","Version Info","AboutDialog"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":93,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"AboutDialog","index":17,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,12,9,13],[9,1,9,4],[6,4,7,8],[54,4,54,5],[56,4,56,5],[54,8,54,9],[56,8,56,9]]}
[null,null,null,null,null,null,null,"Version:","2024.09.12.RJS"]
[null,"SUMMARY"]
[]
[null,null,null,"TIP NUMBER :",{"$f":"IF('Scoping Checklist'!B3=\"\",\"\",'Scoping Checklist'!B3)","v":""},null,null,"IF SUPPLEMENTAL ENTER YES."]
[null,null,null,"COUNTY: ",{"$f":"IF('Scoping Checklist'!B4=\"\",\"\",'Scoping Checklist'!B4)","v":""}]
[]
[null,null,null,"SCOPE :",{"$f":"IF('Scoping Checklist'!B6=\"\",\"\",'Scoping Checklist'!B6)","v":""}]
[]
[]
[null,"PRIVATE ENGINEERING FIRM",null,null,null,"INITIAL",null,"FINAL",null,null,null,null,"COST PER MANDAY CALCULATION CHECK"]
[null,null,null,"ITEM",null,"MD","COST","MD","COST",null,null,null,null,"$/MD"]
[null,null,null,"Roadway",null,{"$f":"Roadway!I47","v":0},{"$f":"Roadway!L55","v":0},null,null,null,null,null,"Roadway",{"$f":"G12/F12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"Roadway!L83","v":0}]
[null,null,null,"TCP/PMP",null,{"$f":"'Traffic Control'!I45","v":0},{"$f":"'Traffic Control'!L53","v":0},null,null,null,null,null,"TCP/PMP",{"$f":"G14/F14","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"'Traffic Control'!L81","v":0}]
[null,null,null,"Hydraulics",null,{"$f":"Hydraulics!I33","v":0},{"$f":"Hydraulics!G114","v":0},null,null,null,null,null,"Hydraulics",{"$f":"G16/F16","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"Hydraulics!G115","v":0}]
[null,null,null,"Structures",null,{"$f":"Structures!I45","v":0},{"$f":"Structures!L53","v":0},null,null,null,null,null,"Structures",{"$f":"G18/F18","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"Structures!L81","v":0}]
[null,null,null,"Location Surveys",null,{"$f":"'Location Surveys'!I62/8","v":0},{"$f":"'Location Surveys'!K71","v":0},null,null,null,null,null,"Location Surveys",{"$f":"G20/F20","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"'Location Surveys'!K79+'Location Surveys'!K82","v":0}]
[null,null,null,"Photogrammetry",null,null,null,null,null,null,null,null,"Photogrammetry"]
[null,null,null,null,"Direct Costs"]
[null,null,null,"Signals",null,null,null,null,null,null,null,null,"Signals"]
[null,null,null,null,"Direct Costs"]
[null,null,null,"Signing",null,null,null,null,null,null,null,null,"Signing"]
[null,null,null,null,"Direct Costs"]
[null,null,null,"Geotechnical ",null,{"$f":"Geotechnical!N35","v":0},{"$f":"Geotechnical!G129","v":0},null,null,null,null,null,"Geotechnical -- Per Bent Cost",{"$f":"GEOTECHNICAL_TOTALperBENT.COST","v":0}]
[null,null,null,null,"Direct Costs",null,{"$f":"SUM(Geotechnical!G130:G131)","v":0},null,null,null,null,null,"Number of Bents",{"$f":"Geotechnical!M8","v":0}]
[null,null,null,"Soils and Foundation",null,null,null,null,null,null,null,null,"Soils and Foundation"]
[null,null,null,null,"Direct Costs"]
[null,null,null,"Trackwork",null,null,null,null,null,null,null,null,"Trackwork"]
[null,null,null,null,"Direct Costs"]
[null,null,null,"Noise Study ",null,null,null,null,null,null,null,null,"Noise Study "]
[null,null,null,null,"Direct Costs"]
[null,null,null,"Utilities--Coord & Design",null,{"$f":"'Utilities--Coord & Design'!I16/8","v":0},{"$f":"SUM('Utilities--Coord & Design'!I20,'Utilities--Coord & Design'!I21,'Utilities--Coord & Design'!I23)","v":0},null,null,null,null,null,"Utilities",{"$f":"G36/F36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"'Utilities--Coord & Design'!I22","v":0}]
[null,null,null,"SUE",null,null,null,null,null,null,null,null,"SUE"]
[null,null,null,null,"Direct Costs"]
[null,null,null,"Right of Way",null,null,{"$f":"'Right of Way'!E16","v":0},null,null,null,null,null,"Right of Way",{"$f":"G40/F40","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs"]
[null,null,null,"PDEA",null,{"$f":"PDEA!D66","v":0},{"$f":"SUM(PDEA!D72,PDEA!D75)","v":0},null,null,null,null,null,"PDEA",{"$f":"G42/F42","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"SUM(PDEA!D73,PDEA!D74)","v":0}]
[null,null,null,"MISCELLANEOUS","SCOPE NAME",{"$f":"MISCELLANEOUS!D135","v":0},{"$f":"SUM(MISCELLANEOUS!D141,MISCELLANEOUS!D144)","v":0},null,null,null,null,null,"MISCELLANEOUS",{"$f":"G44/F44","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Direct Costs",null,{"$f":"SUM(MISCELLANEOUS!D142,MISCELLANEOUS!D143)","v":0}]
[null,null,null,"FIELD SCOPING",null,null,null,"ADDED TO ROADWAY ESTIMATE.",null,null,null,null,"FIELD SCOPING",{"$f":"G46/F46","v":{"$error":"#DIV/0!"}}]
[null,null,null,"PROJECT MGMT. / COORDINATION",null,null,null,"ADDED TO ROADWAY ESTIMATE.",null,null,null,null,"PROJECT MGMT. / COORDINATION",{"$f":"G47/F47","v":{"$error":"#DIV/0!"}}]
[null,null,null,"TOTAL",null,{"$f":"SUM(F12:F47)","v":0},{"$f":"SUM(G12:G47)","v":0},{"$f":"SUM(H12:H43)","v":0},{"$f":"SUM(I12:I43)","v":0}]
[]
[null,null,null,"NOTES: "]
[null,"**",null,"Labor, Overhead & Fee"]
[]
[null,null,null,"ENGINEERING FIRM:",{"$f":"IF('Scoping Checklist'!B7=\"\",\"\",'Scoping Checklist'!B7)","v":""}]
[]
[null,null,null,"PREPARED BY:",null,null,null,"DATE:"]
[]
[null,null,null,"APPROVED BY: ",null,null,null,"DATE:"]

{"sheet":"READMEFIRST","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Save this file to your personal directory before editing any of the sheets."]
["Fill in Scoping Checklist first before proceeding to the other sheets!!!!"]
["Some data will be transferred automatically to other sheets."]
[]
[]
[]
[]
[null,null,"FILL-IN ONLY THE LIGHT-GREEN CELLS.  ALL OTHER CELLS ARE PROTECTED."]

{"sheet":"Title","index":2,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,4,12,7],[37,5,37,7]]}
[]
[]
[null,"COMPUTATION OF MANDAY"]
[null,"REQUIREMENTS AND FEES"]
[]
[null,"prepared for the North Carolina Department of Transportation"]
[]
[null,null,"TIP NO.:",null,{"$f":"IF('Scoping Checklist'!B3=\"\",\"\",'Scoping Checklist'!B3)","v":""}]
[]
[null,null,"COUNTY:",null,{"$f":"IF('Scoping Checklist'!B4=\"\",\"\",'Scoping Checklist'!B4)","v":""}]
[]
[null,null,"DESCRIPTION:",null,{"$f":"IF('Scoping Checklist'!B5=\"\",\"\",'Scoping Checklist'!B5)","v":""}]
[]
[]
[null,null,null,"        ","ENGINEERING AGREEMENT"]
[null,null,null,"        ","SUPPLEMENTAL AGREEMENT NUMBER "]
[null,null,null,"        ","PROFESSIONAL SERVICES CONTRACT"]
[null,null,null,"        ","LIMITED SERVICES CONTRACT"]
[]
[null,null,"CONTENTS: "]
[null,null,null,"COVER",null,null,null,1]
[null,null,null,"SUMMARY",null,null,null,2]
[null,null,null,"SCOPING CHECKLIST",null,null,null,3]
[null,null,null,"ROADWAY",null,null,null,4]
[null,null,null,"TRAFFIC CONTROL",null,null,null,5]
[null,null,null,"HYDRAULICS",null,null,null,6]
[null,null,null,"STRUCTURES",null,null,null,7]
[null,null,null,"LOCATION SURVEYS",null,null,null,8]
[null,null,null,"GEOTECHNICAL",null,null,null,9]
[null,null,null,"UTILITIES",null,null,null,10]
[null,null,null,"PDEA",null,null,null,"11-12"]
[]
[]
[]
[]
[null,null,null,"ENGINEERING FIRM:",null,{"$f":"IF('Scoping Checklist'!B7=\"\",\"\",'Scoping Checklist'!B7)","v":""}]
[]
[null,null,null,"PREPARED BY: "]
[]
[null,null,null,"DATE: "]

{"sheet":"MAX.ALL.NON-SALARY DIRECTS","index":3,"n_rows":98,"n_cols":18,"rows_kept":98,"cut":false,"hidden":false,"merged":[[12,7,12,9],[8,1,8,11],[10,1,10,11],[14,7,14,9],[35,2,35,3],[24,2,24,5],[15,7,15,9],[16,7,16,9],[26,2,26,5],[9,1,9,11],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[38,15,38,18],[17,7,17,9],[18,7,18,9],[19,7,19,9],[21,15,21,18],[32,7,39,10]]}
[]
[]
[]
[null,"STATE OF NORTH CAROLINA"]
[null,"DEPARTMENT OF TRANSPORTATION"]
[null,"           ROY COOPER                                                                                                                              J. ERIC BOYETTE"]
[null,"GOVERNOR                                                                                                                                                                                                                        SECRETARY"]
[null,"2024-09-01"]
[null,"MAXIMUM ALLOWABLE NON-SALARY DIRECT COSTS"]
[]
[null,"CONSULTANTS ARE LIMITED TO THE LOWER OF THEIR ACTUAL RATES OR THE RATES IMPOSED BELOW"]
[null,"REPRODUCTION:",null,null,null,null,null,"42” x 72”",null,null,"11”x17”"]
[null,null,"XEROX COPIES",null,null,0.14000000000000001,null,null,null,null,0.34]
[null,null,"BLUEPRINTS",null,null,0.35,null,1.3]
[null,null,"BOND",null,null,0.42]
[null,null,"BOND (34” X 68”)",null,null,3.5]
[null,null,"VELLUMS",null,null,3]
[null,null,"STICK-ONS",null,null,1]
[null,null,"COVERS",null,null,0.5]
[null,null,"BINDING",null,null,0.5]
[null,null,"MYLARS",null,null,7.32,null,28.12,"(3’x4’)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL PDEA DIRECT COSTS"]
[null,"COMPUTER:","CADD",null,0,"/HR (Recovered Through Overhead)",null,null,null,null,null,null,null,null,null,null,"Parking:",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 1/2 x 11 Color Copies @",0.83]
[null,"OTHER:","FILM & DEVELOPING",null,null,null,20,"/ROLL",null,null,null,null,null,null,null,null,"11 x 17 Color Copies @",1.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SQ. FT. of Plots (B & W or Color) -- <65 SQ. FT.*",6.5]
[null,"MILEAGE:","SEDAN",null,null,null,0.67,"/MILE",null,null,null,null,null,null,null,null,"SQ. FT. of Plots (B & W or Color) -- >65 SQ. FT.*",1.5]
[null,null,"CARRYALL",null,null,null,0.69499999999999995,"/MILE",null,null,null,null,null,null,null,null,"County Tax Maps:",7]
[null,null,"CAR RENTAL",null,50,"/DAY",null,null,null,null,null,null,null,null,null,null,"USGS Maps:",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prints  - 24 x 36 @",3]
[null,null,0.2,"PER MILE FOR GAS IF RENTING",null,null,null,null,null,null,null,null,null,null,null,null,"SQ. FT. Foam Mounting Board @",1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Workshop Supplies @",50]
[null,"SUBSISTENCE:","BREAKFAST",null,10.1,null,null,"1 Hotel reimbursement is limited to actual costs not to exceed: $89.10/day+ tax for in state; $105.20/day + tax for out of state.\n\n$95.00 per day for hotel will be proposed for ALL NCDOT proposals.",null,null,null,null,null,null,null,null,"Laser Peel & Stick (box)",4]
[null,null,"LUNCH",null,13.3,null,null,null,null,null,null,null,null,null,null,null,"Notice or Newsletter @",0.49]
[null,null,"DINNER",null,23.1]
[null,null,"LODGING (actual, up to)",null,89.1,"1"]
[]
[null,null,null,"OTHER HOTEL",105.2,"out-of-state"]
[null,null,null,"OTHER HOTEL",95,"LUMP SUM",null,null,null,null,null,null,null,null,null,"ADDITIONAL WZTCU DIRECT COSTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full-Size Bond (COLOR)",3]
[]
[null,"* Subsistence is an allowance related to lodging and meals (including gratuities)."]
[null,"* Payment of sales tax, lodging tax, local tax or service fees applied to the cost of lodging is allowed in addition to the lodging"]
[null,"rate and is to be paid as a lodging expense."]
[null,"* Reimbursement of actual costs of overnight lodging, whether in-state or out-of-state, must be documented by a receipt of"]
[null,"actual lodging expenses from a commercial establishment."]
[null,"* Out of State travel status only applicable when performing contracted services for NCDOT & requires travel outside of NC."]
[null,"Travel status begins when employee(s) leaves the state and remains in effect until returning to the state."]
[null,"* All subsistence rates comply with NC GS 138-6, the NC Office of State Budget & Management Budget Manual and the"]
[null,"NCDOT Travel Policy and Reimbursement Procedures."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ALL OTHER COSTS MUST SHOW SUPPORTING DOCUMENTATION"]
[]
[null,"ADDRESS ANY QUESTIONS TO THE CONSULTANT, UTILITY, RAIL, TURNPIKE AUDIT UNIT:"]
[]
[]
[null,"John Stroud – Lead Auditor",null,null,null,"919-707-4580",null,"jestroud@ncdot.gov"]
[]
[null,"Shanna Cofield – Lead Auditor",null,null,null,"919-707-4579",null,"slcofield@ncdot.gov"]
[null,"Geavonda Chestnut – Sr. Auditor",null,null,null,"919-707-4597",null,"gchestnut@ncdot.gov"]
[null,"Rosalyn Dobbin - Sr. Auditor",null,null,null,"919-707-4583",null,"rddobbin@ncdot.gov"]
[null,"Amanda Landon - Sr. Auditor",null,null,null,"919-707-4589",null,"aklandon@ncdot.gov"]
[null,"Zack Tarras - Sr. Auditor",null,null,null,"919-707-4584",null,"aztarras@ncdot.gov"]

{"sheet":"Scoping Checklist","index":4,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["NCDOT-PROFESSIONAL SERVICES ROADWAY SCOPING CHECKLIST"]
[]
["TIP NO. :              ",null,null,null,"R/W DATE:",null,null,null,null,"PREPARED BY:     "]
["COUNTY:",null,null,null,"LET DATE:",null,null,null,null,"DATE:"]
["DESCRIPTION:"]
["SCOPE:"]
["CONSULTANT:",null,null,null,"OVERHEAD:",null,null,"FEE:",0.09,"COST of CAPITAL:"]
["SUBCONSULTANT: (1)",null,null,null,"OVERHEAD:",null,null,null,null,"COST of CAPITAL:"]
["SUBCONSULTANT: (2)",null,null,null,"OVERHEAD:",null,null,null,null,"COST of CAPITAL:"]
["SUBCONSULTANT: (3)",null,null,null,"OVERHEAD:",null,null,null,null,"COST of CAPITAL:"]
[]
["BASE INFORMATION"]
[]
["SCALE                                          ",null,null,null,null,null,null,"TYPICAL SECTIONS PER"]
["       PLAN",null,null,"1:",50,null,null,"SHOULDER TYPE"]
["       X-SECTIONS",null,null,"1:",10,null,null,"  BASIC SHOULDER"]
[null,null,null,null,null,null,null,"  BASIC CURB & GUTTER"]
["DESIGN SPEED",null,null,null,null,null,null,"  MEDIAN SHOULDER"]
[null,null,null,null,null,null,null,"  MEDIAN C & G"]
["LENGTH per Hearing Map or Surveys (Miles)"]
["  -L-",null,null,null,null,null,null,"NUMBER OF DRIVEWAY CONNECTIONS"]
["  -Y-",null,null,null,null,null,null,"REQUIRING GRADES "]
["  RPS, LPS, FLYOVERS, C-D's"]
["  SERVICE ROADS",null,null,null,null,null,null,"NUMBER OF BRIDGE SITES"]
["  DETOURS"]
[null,null,null,null,null,null,null,"STRUCTURE RECOMMENDATIONS (Y/N)"]
["NUMBER OF PLAN SHEETS"]
["  -L-",null,null,null,null,null,null,"WALLS (LENGTH in feet)"]
["  -Y-",null,null,null,null,null,null,"  NOISE"]
["  SERVICE ROADS",null,null,null,null,null,null,"  RETAINING"]
["  DETOURS"]
["  INTERCHANGE DETAIL",null,null,null,null,null,null,"CONTROL OF ACCESS (Y/N)"]
[]
["NUMBER OF X-SECTIONS",null,null,null,null,null,null,"NUMBER OF PARCELS"]
["  -L-"]
["  -Y-",null,null,null,null,null,null,"DESIGN EXCEPTIONS (Y/N)"]
["  RPS, LPS, FLYOVERS, C-D's"]
["MULTI-USE PATH",null,null,null,null,null,null,"ADT (THOUSANDS)"]
["  DETOURS"]
[null,null,null,null,null,null,null,"NUMBER OF FIELD INSPECTIONS"]
["NUMBER OF X-SECT SHEETS",null,null,null,null,null,null,"  OVERNIGHT STAY (Y/N)"]
["  -L-"]
["  -Y-",null,null,null,null,null,null,"PUBLIC HEARING  "]
["  RPS, LPS, FLYOVERS, C-D's",null,null,null,null,null,null,"  PREPARE MAP (Y/N)   "]
["MULTI-USE PATH",null,null,null,null,null,null,"  ATTEND MEETING (Y/N)   "]
["  DETOURS"]
[null,null,null,null,null,null,null,"PREPARE CONSTRUCTION PLANS (Y/N)"]
["NUMBER OF MEDIAN DETOUR X-OVERS"]
[null,null,null,null,null,null,null,"OVERALL COMPLEXITY (LOW/MED/HIGH)"]
["NUMBER OF AT-GRADE INTERSECTIONS"]
["  4 LEG",null,null,null,null,null,null,"SPECIAL CONSIDERATIONS (Y/N)"]
["  T (NOT INCLUDING BULB)",null,null,null,null,null,null,"   LIST BELOW:"]
["  BULB"]
[]
["NUMBER OF INTERCHANGES "]
["  SIMPLE (DIAMOND, TRUMPET)"]
["    4 LEG"]
["    3 LEG"]
["  INTERMEDIATE (CLOVERLEAFS)"]
["  DIFFICULT (DIRECTIONAL, MULTILEVEL)"]
[]
[]
["INTERNAL USE ONLY "]
["TYPE of PROJECT (B, S, I, D)"]
["(Bridge Replacement, Simple, Intermediate, Difficult)"]

{"sheet":"LIBRP_PEF CLASSIFICATION SHEET","index":5,"n_rows":102,"n_cols":7,"rows_kept":102,"cut":false,"hidden":false,"merged":[[4,2,4,6]]}
[]
[null,"TIP NO. :              ",{"$f":"'Scoping Checklist'!B3","v":0}]
[null,"COUNTY:",{"$f":"'Scoping Checklist'!B4","v":0}]
[null,"DESCRIPTION:",{"$f":"'Scoping Checklist'!B5","v":0}]
[null,"SCOPE:",{"$f":"'Scoping Checklist'!B6","v":0}]
[]
[]
[null,null,"CONSULTANT NAME"]
[null,"DISCIPLINE","CLASSIFICATION","EMPLOYEE NAME","RAW HOURLY RATE","OVERHEAD","Cost of Capital"]
[]
[null,"Roadway"]
[null,null,"Associate Engineer"]
[null,null,"Senior Engineer"]
[null,null,"Design Engineer (EI)"]
[null,null,"Senior Technician"]
[null,null,"Technician"]
[null,null,"Draftsperson"]
[]
[null,"Traffic Control"]
[null,null,"Associate Engineer"]
[null,null,"Senior Engineer"]
[null,null,"Design Engineer (EI)"]
[null,null,"Senior Technician"]
[null,null,"Technician"]
[null,null,"Draftsperson"]
[]
[null,"Hydraulics"]
[null,null,"TES III"]
[null,null,"TE III"]
[null,null,"TE II"]
[null,null,"TE I"]
[null,null,"TT IV"]
[null,null,"TT II"]
[]
[null,"Structures"]
[null,null,"Associate Engineer"]
[null,null,"Senior Engineer"]
[null,null,"Design Engineer (EI)"]
[null,null,"Senior Technician"]
[null,null,"Technician"]
[null,null,"Draftsperson"]
[]
[null,"Location Surveys"]
[null,null,"Project Engineer Manager"]
[null,null,"Project Survey Supervisor"]
[null,null,"Advanced Survey Coordinator"]
[null,null,"Survey Crew Leader"]
[null,null,"Assistant Survey Crew Leader"]
[null,null,"Survey Crew Member"]
[]
[null,"Geotechnical "]
[null,null,"TEM I"]
[null,null,"TES II"]
[null,null,"TE II"]
[null,null,"TEG II"]
[null,null,"TEG I"]
[null,null,"TT III CADD"]
[null,null,"TT III"]
[null,null,"TT II"]
[null,null,"TTA II"]
[null,null,"OA IV"]
[null,null,"OA III"]
[]
[null,"Utilities--Coord & Design"]
[null,null,"Principal or Project Engineer or TES III"]
[null,null,"Project Design Engineer or TES II"]
[null,null,"Senior Engineer or TE II"]
[null,null,"Junior Engineer or TE I"]
[null,null,"Senior Technician or TT IV"]
[null,null,"Junior Technician or TT II"]
[]
[null,"PDEA"]
[null,null,"BRANCH MAN.(TD-1)"]
[null,null,"UNIT HEAD(TM-1)"]
[null,null,"GROUP MAN.(TES-3)"]
[null,null,"PROJ. ENG.(TE-3)(TE-2)"]
[null,null,"DRAFT& REPO.TECH.(TT-2)"]
[null,null,"COMM.PLNR(CP-2)"]
[null,null,"ENV.SPVR./ENGR.(TE-3)(ES-3)"]
[null,null,"ENV.SPEC.(ES-3)(ES-2)"]
[null,null,"ARCH. & HISTORIC SPVR."]
[null,null,"ARCH. & HISTORIC SPEC. (ARCH-2)(HPRS-2)"]
[null,null,"TRANS.ENG.SPVR.(TE-3))"]
[null,null,"TRANS.ENG.(TE-1)"]
[null,null,"ENV.TECH 3 (TT-3)"]
[null,null,"WORD.PROC.SPVR.(WP-2)"]
[]
[null,"MISCELLANEOUS"]
[null,null,"CLASSIFICATION 1"]
[null,null,"CLASSIFICATION 2"]
[null,null,"CLASSIFICATION 3"]
[null,null,"CLASSIFICATION 4"]
[null,null,"CLASSIFICATION 5"]
[null,null,"CLASSIFICATION 6"]
[null,null,"CLASSIFICATION 7"]
[null,null,"CLASSIFICATION 8"]
[null,null,"CLASSIFICATION 9"]
[null,null,"CLASSIFICATION 10"]
[null,null,"CLASSIFICATION 11"]
[null,null,"CLASSIFICATION 12"]
[null,null,"CLASSIFICATION 13"]
[null,null,"CLASSIFICATION 14"]

{"sheet":"Roadway","index":6,"n_rows":91,"n_cols":12,"rows_kept":91,"cut":false,"hidden":true,"merged":[[11,10,11,15],[44,4,44,6],[35,8,35,10],[39,4,39,6],[40,4,40,6],[43,4,43,6],[42,4,42,6],[0,1,0,15],[2,7,2,8],[5,10,5,15],[6,10,6,15],[7,10,7,15],[2,10,2,15],[3,10,3,15],[4,10,4,15],[8,10,8,15],[9,10,9,15],[45,5,45,6],[12,10,12,15],[25,10,25,15],[26,10,26,15],[27,10,27,15],[20,10,20,15],[16,10,16,15],[10,10,10,15],[41,4,41,6],[13,10,13,15],[14,10,14,15],[33,2,33,11],[15,10,15,15],[19,10,19,15]]}
[null,"LOW-IMPACT BRIDGE REPLACEMENT PROGRAM"]
[]
[null,"MANHOURS BY CLASSIFICATION",null,null,null,null,null,"TOTAL",null,null,"PROJECT PHASE"]
[null,"ASSOC ENGR","SENIOR ENGR","DESIGN ENGR(EI)","SENIOR TECH","TECH","DRAFTER","MANHOURS","MANDAYS",null,"LOW-IMPACT BRIDGE REPLACEMENT PLANS"]
[null,null,null,null,null,null,null,{"$f":"SUM(B5:G5)","v":0},{"$f":"H5/8","v":0},null,"Roadway Alignment and Grade (Horizontal & Vertical)"]
[null,null,null,null,null,null,null,0,0,null,"Roadway Typical & Cross Sections (Slope Stakes & Earthwork)"]
[null,null,null,null,null,null,null,0,0,null,"Roadway Design Exception (Checklist and Letter)"]
[null,null,null,null,null,null,null,0,0,null,"Roadway Drainage (Drafting pipes, etc.)"]
[null,null,null,null,null,null,null,0,0,null,"Roadway Guardrail (Design and Draft)"]
[null,null,null,null,null,null,null,0,0,null,"Roadway Right of Way"]
[null,null,null,null,null,null,null,0,0,null,"Roadway Quantities"]
[null,null,null,null,null,null,null,0,0,null,"Construction Proposal Preparation"]
[null,null,null,null,null,null,null,0,0,null,"Roadway Meetings / Coordination"]
[null,null,null,null,null,null,null,0,0,null,"OTHERS (LIST):"]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(B18:G18)","v":0},{"$f":"H18/8","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(B19:G19)","v":0},{"$f":"H19/8","v":0}]
[null,null,null,null,null,null,null,0,0,null,"FIELD SCOPING (1.0 MD, MAX. -- NOT FOR SUPPLEMENTALS)."]
[null,null,null,null,null,null,null,0,0,null,"PROJECT MGMT. / COORDINATION (5.0 MDs, MAX. -- NOT FOR SUPPLEMENTALS)."]
[null,{"$f":"SUM(B5:B21)","v":0},0,0,0,0,0]
[null,null,"TOTAL for FINAL PLANS",null,null,null,null,{"$f":"SUM(H5:H21)","v":0},{"$f":"SUM(I5:I21)","v":0}]
[]
[null,null,null,null,null,null,null,"SUMMARY"]
[]
[null,null,null,null,null,null,null,null,null,null,"SEE ROADWAY DESIGN EMPLOYEE CLASSIFICATION"]
[null,null,null,"FINAL PLANS",null,null,null,{"$f":"H23","v":0},{"$f":"I23","v":0},null,"FOR CALCULATED COSTS."]
[]
[null,null,null,"TOTAL for  ROADWAY DESIGN",null,null,null,{"$f":"H28","v":0},{"$f":"I28","v":0}]
[]
[]
[]
[null,null,"ROADWAY DESIGN EMPLOYEE CLASSIFICATION"]
[]
[null,null,"TIP NO.:",{"$f":"IF('Scoping Checklist'!B3=\"\",\"\",'Scoping Checklist'!B3)","v":""},null,null,null,"PEF NAME:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C11","v":0}]
[null,null,"COUNTY: ",{"$f":"IF('Scoping Checklist'!B4=\"\",\"\",'Scoping Checklist'!B4)","v":""}]
[]
[null,null,"CLASSIFICATION",null,"EMPLOYEE NAME",null,null,"MANHOURS","MANDAYS",null,"RATE","COST"]
[null,null,"Associate Engineer",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D12","v":0},null,null,{"$f":"B22","v":0},{"$f":"H40/8","v":0},"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E12","v":0},{"$f":"H40*K40","v":0}]
[null,null,"Senior Engineer",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D13","v":0},null,null,{"$f":"C22","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E13","v":0},0]
[null,null,"Design Engineer (EI)",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D14","v":0},null,null,{"$f":"D22","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E14","v":0},0]
[null,null,"Senior Technician",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D15","v":0},null,null,{"$f":"E22","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E15","v":0},0]
[null,null,"Technician",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D16","v":0},null,null,{"$f":"F22","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E16","v":0},0]
[null,null,"Draftsperson",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D17","v":0},null,null,{"$f":"G22","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E17","v":0},0]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H40:H45)","v":0},{"$f":"SUM(I40:I45)","v":0}]
[null,null,"Total Direct Salary",null,null,null,null,null,null,null,null,{"$f":"SUM(L40:L45)","v":0}]
[null,null,"Escalation (per year)",null,null,null,0.02,null,null,null,"N/A"]
[null,null,"Overhead ",null,null,null,null,null,null,"AS A PERCENTAGE (xxx.xx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F11","v":0},{"$f":"(L48+L49)*K50","v":0}]
[null,null,"Subtotal",null,null,null,null,null,null,null,null,{"$f":"(L48+L49)*(1+K50)","v":0}]
[null,null,"Fee",null,null,null,null,null,null,null,0.09,{"$f":"L51*K52","v":0}]
[null,null,"Overhead (Cost of Capital)",null,null,null,null,null,null,"AS A PERCENTAGE (x.xxxx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G11","v":0},{"$f":"L48*K53","v":0}]
[]
[null,null,"TOTAL DIRECT AND INDIRECT SALARY COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L51:L53)","v":0}]
[]
[]
[]
[null,null,null,null,null,"DIRECT COSTS"]
[null,null,null,null,null,null,null,"Paper copies"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"8-1/2\"x11\"",null,"x",{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"I62*K62","v":0}]
[null,null,null,null,null,null,null,"11\"x17\"",null,"x",{"$f":"LEDGERCOPIES","v":0.34},{"$f":"I63*K63","v":0}]
[null,null,null,null,null,null,null,"Bond (34\"x22\")",null,"x",{"$f":"BOND.REGULAR","v":0.42},{"$f":"I64*K64","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Miscellaneous"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"Postage and Fax",null,"x",null,{"$f":"I69*K69","v":0}]
[null,null,null,null,null,null,null,"Film and Developing",null,"x",{"$f":"FILM","v":20},{"$f":"I70*K70","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Travel"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"Breakfast",null,"x",{"$f":"BREAKFAST","v":10.1},{"$f":"I75*K75","v":0}]
[null,null,null,null,null,null,null,"Lunch",null,"x",{"$f":"LUNCH","v":13.3},0]
[null,null,null,null,null,null,null,"Supper",null,"x",{"$f":"DINNER","v":23.1},0]
[null,null,null,null,null,null,null,"Overnight per Diem",null,"x",{"$f":"LODGING_LUMP.SUM","v":95},0]
[null,null,null,null,null,null,null,"Mileage (Sedan)",null,null,{"$f":"SEDAN","v":0.67},0]
[null,null,null,null,null,null,null,"Mileage (Carryall)",null,"x",{"$f":"CARRYALL","v":0.69499999999999995},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL  =",{"$f":"SUM(L62:L80)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL =",{"$f":"L55+L83","v":0}]

{"sheet":"Traffic Control","index":7,"n_rows":89,"n_cols":12,"rows_kept":89,"cut":false,"hidden":true,"merged":[[33,8,33,10],[37,4,37,6],[38,4,38,6],[39,4,39,6],[43,5,43,6],[40,4,40,6],[41,4,41,6],[42,4,42,6],[0,1,0,15],[4,10,4,15],[10,10,10,15],[11,10,11,15],[2,7,2,8],[5,10,5,15],[3,10,3,15],[2,10,2,15],[6,10,6,15],[7,10,7,15],[13,10,13,15],[14,10,14,15],[15,10,15,15],[8,10,8,15],[9,10,9,15],[12,10,12,15],[31,2,31,11],[23,10,23,15],[24,10,24,15],[25,10,25,15],[16,10,16,15],[17,10,17,15],[18,10,18,15]]}
[null,"LOW-IMPACT BRIDGE REPLACEMENT PROGRAM"]
[]
[null,"MANHOURS BY CLASSIFICATION",null,null,null,null,null,"TOTAL",null,null,"PROJECT PHASE"]
[null,"ASSOC ENGR","SENIOR ENGR","DESIGN ENGR(EI)","SENIOR TECH","TECH","DRAFTER","MANHOURS","MANDAYS",null,"LOW-IMPACT BRIDGE REPLACEMENT PLANS"]
[null,null,null,null,null,null,null,{"$f":"SUM(B5:G5)","v":0},{"$f":"H5/8","v":0},null,"Review Roadway Plans "]
[null,null,null,null,null,null,null,0,0,null,"Develop Traffic Control Plan (Roadway Standards, Project Notes, Phasing, Detail Drawings, Detour Details, Route Signing, etc.) "]
[null,null,null,null,null,null,null,0,0,null,"Traffic Control Quantities"]
[null,null,null,null,null,null,null,0,0,null,"Traffic Control Meetings/Coordination"]
[null,null,null,null,null,null,null,0,0,null,"Traffic Control Miscellaneous"]
[null,null,null,null,null,null,null,0,0,null,"OTHERS (LIST):"]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,{"$f":"SUM(B5:B19)","v":0},0,0,0,0,0]
[null,null,"TOTAL for FINAL PLANS",null,null,null,null,{"$f":"SUM(H5:H19)","v":0},{"$f":"SUM(I5:I19)","v":0}]
[]
[null,null,null,null,null,null,null,"SUMMARY"]
[]
[null,null,null,null,null,null,null,null,null,null,"SEE ROADWAY DESIGN EMPLOYEE CLASSIFICATION"]
[null,null,null,"FINAL PLANS",null,null,null,{"$f":"H21","v":0},{"$f":"I21","v":0},null,"FOR CALCULATED COSTS."]
[]
[null,null,null,"TOTAL for  ROADWAY DESIGN",null,null,null,{"$f":"H26","v":0},{"$f":"I26","v":0}]
[]
[]
[]
[null,null,"TRAFFIC CONTROL EMPLOYEE CLASSIFICATION"]
[]
[null,null,"TIP NO.:",{"$f":"IF('Scoping Checklist'!B3=\"\",\"\",'Scoping Checklist'!B3)","v":""},null,null,null,"PEF NAME:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C19","v":0}]
[null,null,"COUNTY: ",{"$f":"IF('Scoping Checklist'!B4=\"\",\"\",'Scoping Checklist'!B4)","v":""}]
[]
[null,null,"CLASSIFICATION",null,"EMPLOYEE NAME",null,null,"MANHOURS","MANDAYS",null,"RATE","COST"]
[null,null,"Associate Engineer",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D20","v":0},null,null,{"$f":"B20","v":0},{"$f":"H38/8","v":0},"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E20","v":0},{"$f":"H38*K38","v":0}]
[null,null,"Senior Engineer",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D21","v":0},null,null,{"$f":"C20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E21","v":0},0]
[null,null,"Design Engineer (EI)",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D22","v":0},null,null,{"$f":"D20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E22","v":0},0]
[null,null,"Senior Technician",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D23","v":0},null,null,{"$f":"E20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E23","v":0},0]
[null,null,"Technician",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D24","v":0},null,null,{"$f":"F20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E24","v":0},0]
[null,null,"Draftsperson",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D25","v":0},null,null,{"$f":"G20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E25","v":0},0]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H38:H43)","v":0},{"$f":"SUM(I38:I43)","v":0}]
[null,null,"Total Direct Salary",null,null,null,null,null,null,null,null,{"$f":"SUM(L38:L43)","v":0}]
[null,null,"Escalation (per year)",null,null,null,0.02,null,null,null,"N/A"]
[null,null,"Overhead ",null,null,null,null,null,null,"AS A PERCENTAGE (xxx.xx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F19","v":0},{"$f":"(L46+L47)*K48","v":0}]
[null,null,"Subtotal",null,null,null,null,null,null,null,null,{"$f":"(L46+L47)*(1+K48)","v":0}]
[null,null,"Fee",null,null,null,null,null,null,null,0.09,{"$f":"L49*K50","v":0}]
[null,null,"Overhead (Cost of Capital)",null,null,null,null,null,null,"AS A PERCENTAGE (x.xxxx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G19","v":0},{"$f":"L46*K51","v":0}]
[]
[null,null,"TOTAL DIRECT AND INDIRECT SALARY COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L49:L51)","v":0}]
[]
[]
[]
[null,null,null,null,null,"DIRECT COSTS"]
[null,null,null,null,null,null,null,"Paper copies"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"8-1/2\"x11\"",null,"x",{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"I60*K60","v":0}]
[null,null,null,null,null,null,null,"11\"x17\"",null,"x",{"$f":"LEDGERCOPIES","v":0.34},{"$f":"I61*K61","v":0}]
[null,null,null,null,null,null,null,"Bond (34\"x22\")",null,"x",{"$f":"BOND.REGULAR","v":0.42},{"$f":"I62*K62","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Miscellaneous"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"Postage and Fax",null,"x",null,{"$f":"I67*K67","v":0}]
[null,null,null,null,null,null,null,"Film and Developing",null,"x",{"$f":"FILM","v":20},{"$f":"I68*K68","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Travel"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"Breakfast",null,"x",{"$f":"BREAKFAST","v":10.1},{"$f":"I73*K73","v":0}]
[null,null,null,null,null,null,null,"Lunch",null,"x",{"$f":"LUNCH","v":13.3},0]
[null,null,null,null,null,null,null,"Supper",null,"x",{"$f":"DINNER","v":23.1},0]
[null,null,null,null,null,null,null,"Overnight per Diem",null,"x",{"$f":"LODGING_LUMP.SUM","v":95},0]
[null,null,null,null,null,null,null,"Mileage (Sedan)",null,null,{"$f":"SEDAN","v":0.67},0]
[null,null,null,null,null,null,null,"Mileage (Carryall)",null,"x",{"$f":"CARRYALL","v":0.69499999999999995},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL  =",{"$f":"SUM(L60:L78)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL =",{"$f":"L53+L81","v":0}]

{"sheet":"Hydraulics","index":8,"n_rows":117,"n_cols":14,"rows_kept":117,"cut":false,"hidden":true,"merged":[[9,3,11,7],[14,3,14,8],[36,2,43,5],[46,2,49,4],[4,8,4,9],[65,2,65,3],[66,2,66,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3]]}
[]
[]
[null,null,"                              COST ESTIMATE FOR HYDROLOGIC/HYDRAULIC DESIGN STUDY"]
[null,null,"  ",null,"          FOR B, R, U, AND I PROJECTS"]
[null,null,null,null,"              DATE:",null,null,"PEF NAME:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C27","v":0}]
[]
[null,null,"TIP:",{"$f":"IF('Scoping Checklist'!B3=\"\",\"\",'Scoping Checklist'!B3)","v":""},"    COUNTY:",{"$f":"IF('Scoping Checklist'!B4=\"\",\"\",'Scoping Checklist'!B4)","v":""},null,"                COMPILED BY:"]
[]
[]
[null,null,"PROJECT DESCRIPTION:"]
[]
[]
[]
[]
[null,null,null,"MANHOURS BY CLASSIFICATION"]
[null,null,"TASKS","TES III","TE III","TE II","TE I","TT IV","TT II","TOTAL MANHOURS"]
[null,null,"PRE-DESIGN REVIEW & DATA COLLECTION ",null,null,null,null,null,null,{"$f":"SUM(D17:I17)","v":0},{"$f":"J17/8","v":0}]
[null,null,"FIELD RECONNAISSANCE & SUPPLEMENTARY SURVEYS",null,null,null,null,null,null,{"$f":"SUM(D18:I18)","v":0},{"$f":"J18/8","v":0}]
[null,null,"HYDROLOGIC AND HYDRAULIC DESIGN:",null,null,null,null,null,null,0,0]
[null,null,"1. BRIDGES  (1)",null,null,null,null,null,null,0,0]
[null,null,"PREPARE PERMIT DRAWINGS",null,null,null,null,null,null,0,0]
[null,null,"EROSION CONTROL PLAN",null,null,null,null,null,null,{"$f":"SUM(D22:I22)","v":0},0]
[null,null,"MOA  (1)",null,null,null,null,null,null,0,0]
[null,null,"PLAN FIELD INSPECTION(S)  (1)",null,null,null,null,null,null,0,0]
[null,null,"REVIEW & REWORK",null,null,null,null,null,null,0]
[null,null,"MISCELLANEOUS -- should not be used for LIBRP's.",null,null,null,null,null,null,0]
[null,null,"MISCELLANEOUS -- should not be used for LIBRP's.",null,null,null,null,null,null,0]
[null,null,"MISCELLANEOUS -- should not be used for LIBRP's.",null,null,null,null,null,null,0]
[null,null,"MISCELLANEOUS -- should not be used for LIBRP's.",null,null,null,null,null,null,0]
[null,null,"MISCELLANEOUS -- should not be used for LIBRP's.",null,null,null,null,null,null,0,0]
[null,null,"TOTAL MANHOURS:",{"$f":"SUM(D17:D30)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I32:M32)","v":0}]
[null,null,null,null,null,null,null,"TOTAL MANDAYS",{"$f":"SUM(D31:I31)/8","v":0}]
[]
[]
[]
[null,null,"Total BRIDGE Manhours should include:\n1)  Bridge Report;\n2)  Bridge Spread and Deck Drain Analysis;\n3)  Pipes, Storm Drainage and Ditches;\n4)  CADD."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total PERMIT Manhours should include:\n1)  Stormwater Management Plan;\n2)  CADD."]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C4","v":"  "}]
[null,null,"Page 2 of 2","TIP:",{"$f":"D7","v":""},null,"Date:",{"$f":"F5","v":"00:00:00"}]
[]
[null,null,null,null,"HYDRAULICS  DESIGN"]
[]
[null,null,"I.  ENGINEERING SERVICES"]
[null,null,"  DIRECT SALARY COST:"]
[null,null,"Employee Name",null,"Classification","Hours","Rate","Cost",null,null,null,null,{"$f":"SUM(F61:L61)","v":0}]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D28","v":0},null,"TES III",{"$f":"D31","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E28","v":0},{"$f":"F62*G62","v":0}]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D29","v":0},null,"TE III",{"$f":"E31","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E29","v":0},0]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D30","v":0},null,"TE II",{"$f":"F31","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E30","v":0},0]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D31","v":0},null,"TE I",{"$f":"G31","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E31","v":0},0]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D32","v":0},null,"TT IV",{"$f":"H31","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E32","v":0},0]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D33","v":0},null,"TT II",{"$f":"I31","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E33","v":0},0]
[null,null,null,null,"TOTAL MANHOURS",{"$f":"SUM(F62:F67)","v":0}]
[null,null,null,null,"TOTAL MANDAYS",{"$f":"F68/8","v":0}]
[]
[null,null,null,null,"TOTAL DIRECT SALARY COST:",null,null,{"$f":"SUM(H62:H67)","v":0}]
[null,null,null,null,"OVERHEAD (%):",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F27","v":0},{"$f":"H71*G72","v":0}]
[null,null,null,null,"SUBTOTAL:",null,0,{"$f":"SUM(H71:H72)","v":0}]
[null,null,null,null,"FIXED FEE",null,0.09,{"$f":"G74*(H73)","v":0}]
[null,null,null,null,"COST OF CAPITAL (%):",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G27","v":0},{"$f":"H71*G75","v":0}]
[]
[null,null,null,null,"TOTAL DIRECT AND INDIRECT SALARY COST:",null,null,{"$f":"SUM(H73:H75)","v":0}]
[]
[null,null,"(1)      Group positions by general classifications;  Project Manager, "]
[null,null,"          Project Engineer, Design Engineer, Senior Technician, Tech./Draft"]
[null,null,"(2)     Maximum billing rates for classifications:"]
[]
[null,null,"                 Project Manager                              $118.10/hr."]
[null,null,"                 Project Engineer                              $92.16/hr."]
[null,null,"                 Design Engineer                              $76.04/hr."]
[null,null,"                 Senior Technician                            $64.76/hr."]
[null,null,"                      Tech/Draft                                        $53.35/hr."]
[]
[]
[]
[]
[null,null,"II.  MISCELLANEOUS COST"]
[null,null,"  TRAVEL EXPENSE:"]
[]
[null,null,"MILEAGE:",null,"Number of trips"]
[null,null,null,null,"Miles/Trip"]
[null,null,null,null,{"$f":"SEDAN","v":0.67},"(per mile) X",null,"Miles =",{"$f":"E97*G97","v":0}]
[null,null,null,null,{"$f":"CARRYALL","v":0.69499999999999995},"(per mile) X",null,"Miles =",{"$f":"E98*G98","v":0}]
[null,null,null,null,null,null,"in town traveling"]
[null,null,"PER DIEM EXPENSE:"]
[null,null,null,null,{"$f":"LODGING_LUMP.SUM+BREAKFAST+LUNCH+DINNER","v":141.5},"(per day) X",null,"Days =",{"$f":"E101*G101","v":0}]
[]
[null,null,"Special Equip. Rental",null,null,"(time)x",null,"Rate  = ",{"$f":"E103*G103","v":0}]
[null,null,"Type="]
[]
[]
[null,null,"MISCELLANEOUS EXPENSES:",null,null,"FILM & PROCESSING:"]
[null,null,null,null,null,"HEC2 DATA FILES:",null,null,0]
[]
[null,null,null,null,null,"ESTIMATED TOTAL MISC. COST",null,null,{"$f":"SUM(I97:I108)","v":0}]
[]
[null,null,"III.  SUMMARY"]
[]
[null,null,"     ENGINEERING SERVICES",null,null,null,{"$f":"H77","v":0}]
[null,null,"       MISCELLANEOUS COST",null,null,null,{"$f":"I110","v":0}]
[]
[null,null,"    PROJECT ESTIMATE TOTAL:",null,null,null,{"$f":"G114+G115","v":0}]

{"sheet":"Structures","index":9,"n_rows":89,"n_cols":12,"rows_kept":89,"cut":false,"hidden":true,"merged":[[33,8,33,10],[37,4,37,6],[38,4,38,6],[39,4,39,6],[43,5,43,6],[40,4,40,6],[41,4,41,6],[42,4,42,6],[0,1,0,15],[4,10,4,15],[10,10,10,15],[11,10,11,15],[2,7,2,8],[5,10,5,15],[3,10,3,15],[2,10,2,15],[6,10,6,15],[7,10,7,15],[13,10,13,15],[14,10,14,15],[15,10,15,15],[8,10,8,15],[9,10,9,15],[12,10,12,15],[31,2,31,11],[23,10,23,15],[24,10,24,15],[25,10,25,15],[16,10,16,15],[17,10,17,15],[18,10,18,15]]}
[null,"LOW-IMPACT BRIDGE REPLACEMENT PROGRAM"]
[]
[null,"MANHOURS BY CLASSIFICATION",null,null,null,null,null,"TOTAL",null,null,"PROJECT PHASE"]
[null,"ASSOC ENGR","SENIOR ENGR","DESIGN ENGR(EI)","SENIOR TECH","TECH","DRAFTER","MANHOURS","MANDAYS",null,"LOW-IMPACT BRIDGE REPLACEMENT PLANS"]
[null,null,null,null,null,null,null,{"$f":"SUM(B5:G5)","v":0},{"$f":"H5/8","v":0},null,"Prepare General Drawing (Plan & Elevation views,\nLocation Sketch, Notes, Bill of Material)"]
[null,null,null,null,null,null,null,0,0,null,"OTHERS (LIST):"]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,{"$f":"SUM(B5:B19)","v":0},0,0,0,0,0]
[null,null,"TOTAL for FINAL PLANS",null,null,null,null,{"$f":"SUM(H5:H19)","v":0},{"$f":"SUM(I5:I19)","v":0}]
[]
[null,null,null,null,null,null,null,"SUMMARY"]
[]
[null,null,null,null,null,null,null,null,null,null,"SEE ROADWAY DESIGN EMPLOYEE CLASSIFICATION"]
[null,null,null,"FINAL PLANS",null,null,null,{"$f":"H21","v":0},{"$f":"I21","v":0},null,"FOR CALCULATED COSTS."]
[]
[null,null,null,"TOTAL for  ROADWAY DESIGN",null,null,null,{"$f":"H26","v":0},{"$f":"I26","v":0}]
[]
[]
[]
[null,null,"STRUCTURE DESIGN EMPLOYEE CLASSIFICATION"]
[]
[null,null,"TIP NO.:",{"$f":"IF('Scoping Checklist'!B3=\"\",\"\",'Scoping Checklist'!B3)","v":""},null,null,null,"PEF NAME:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C35","v":0}]
[null,null,"COUNTY: ",{"$f":"IF('Scoping Checklist'!B4=\"\",\"\",'Scoping Checklist'!B4)","v":""}]
[]
[null,null,"CLASSIFICATION",null,"EMPLOYEE NAME",null,null,"MANHOURS","MANDAYS",null,"RATE","COST"]
[null,null,"Associate Engineer",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D36","v":0},null,null,{"$f":"B20","v":0},{"$f":"H38/8","v":0},"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E36","v":0},{"$f":"H38*K38","v":0}]
[null,null,"Senior Engineer",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D37","v":0},null,null,{"$f":"C20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E37","v":0},0]
[null,null,"Design Engineer (EI)",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D38","v":0},null,null,{"$f":"D20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E38","v":0},0]
[null,null,"Senior Technician",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D39","v":0},null,null,{"$f":"E20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E39","v":0},0]
[null,null,"Technician",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D40","v":0},null,null,{"$f":"F20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E40","v":0},0]
[null,null,"Draftsperson",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D41","v":0},null,null,{"$f":"G20","v":0},0,"x",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E41","v":0},0]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H38:H43)","v":0},{"$f":"SUM(I38:I43)","v":0}]
[null,null,"Total Direct Salary",null,null,null,null,null,null,null,null,{"$f":"SUM(L38:L43)","v":0}]
[null,null,"Escalation (per year)",null,null,null,0.02,null,null,null,"N/A"]
[null,null,"Overhead ",null,null,null,null,null,null,"AS A PERCENTAGE (xxx.xx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F35","v":0},{"$f":"(L46+L47)*K48","v":0}]
[null,null,"Subtotal",null,null,null,null,null,null,null,null,{"$f":"(L46+L47)*(1+K48)","v":0}]
[null,null,"Fee",null,null,null,null,null,null,null,0.09,{"$f":"L49*K50","v":0}]
[null,null,"Overhead (Cost of Capital)",null,null,null,null,null,null,"AS A PERCENTAGE (x.xxxx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G35","v":0},{"$f":"L46*K51","v":0}]
[]
[null,null,"TOTAL DIRECT AND INDIRECT SALARY COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L49:L51)","v":0}]
[]
[]
[]
[null,null,null,null,null,"DIRECT COSTS"]
[null,null,null,null,null,null,null,"Paper copies"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"8-1/2\"x11\"",null,"x",{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"I60*K60","v":0}]
[null,null,null,null,null,null,null,"11\"x17\"",null,"x",{"$f":"LEDGERCOPIES","v":0.34},{"$f":"I61*K61","v":0}]
[null,null,null,null,null,null,null,"Bond (34\"x22\")",null,"x",{"$f":"BOND.REGULAR","v":0.42},{"$f":"I62*K62","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Miscellaneous"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"Postage and Fax",null,"x",null,{"$f":"I67*K67","v":0}]
[null,null,null,null,null,null,null,"Film and Developing",null,"x",{"$f":"FILM","v":20},{"$f":"I68*K68","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Travel"]
[null,null,null,null,null,null,null,null,"Number",null,"Cost"]
[null,null,null,null,null,null,null,"Breakfast",null,"x",{"$f":"BREAKFAST","v":10.1},{"$f":"I73*K73","v":0}]
[null,null,null,null,null,null,null,"Lunch",null,"x",{"$f":"LUNCH","v":13.3},0]
[null,null,null,null,null,null,null,"Supper",null,"x",{"$f":"DINNER","v":23.1},0]
[null,null,null,null,null,null,null,"Overnight per Diem",null,"x",{"$f":"LODGING_LUMP.SUM","v":95},0]
[null,null,null,null,null,null,null,"Mileage (Sedan)",null,null,{"$f":"SEDAN","v":0.67},0]
[null,null,null,null,null,null,null,"Mileage (Carryall)",null,"x",{"$f":"CARRYALL","v":0.69499999999999995},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL  =",{"$f":"SUM(L60:L78)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL =",{"$f":"L53+L81","v":0}]

{"sheet":"Location Surveys","index":10,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":true,"merged":[[16,3,16,10],[5,4,5,7],[3,4,3,7],[7,4,7,7],[9,4,9,7],[15,3,15,10]]}
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,1]
["LOCATION AND SURVEYS PEF COST ESTIMATE FOR LOW IMPACT BRIDGES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
[null,null,null,"DATE:",null,null,null,null,null,null,null," ","FT"]
[null,null,null,null,null,null,null,null,null,null,null," ","KM"]
[null,null,null,"FIRM:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C43","v":0},null,null,null,null,null,null," "]
[]
[null,null,null,"SUB:"]
[]
["PROJECT:",null,null,"COUNTY:",null,null,null,null,null,"TIP NO.:"]
[]
["LENGTH:",null,null,null,null,null,null,null,null,"LS NO.:"]
[null,"L-LINE:",null,{"$f":"INDEX(M3:M5,M1)","v":"MI"},null,null,null,"RAMPS:",null,{"$f":"INDEX(M3:M5,M1)","v":"MI"}]
[null,"Y-LINE(S):",null,{"$f":"INDEX(M3:M5,M1)","v":"MI"},null,null,null,"RAILROADS:",null,{"$f":"INDEX(M3:M5,M1)","v":"MI"}]
[]
[null,null,"PROJECT DESCRIPTION:"]
[]
[]
[null,null,null,"MANHOURS BY CLASSIFICATION"]
["TASKS & PARAMETERS",null,null,"PEM","PSS","ASC","SCL","ASCL","SCM","TOTAL"]
["3. NC Grid Tie (Horiz.) to NAD 1983"]
[null,"Approx. Length:",null,null,null,null,null,null,null,{"$f":"SUM(D22:I22)","v":0},null,1,"…"]
["4. Vertical Control Tie to NGVD of 1929",null,null,null,null,null,null,null,null,null,null,"11.  Obtain STA Levels w/out EP Shots"]
[null,"Approx. Length:",null,null,null,null,null,null,null,{"$f":"SUM(D24:I24)","v":0},null,"11.  Obtain Random Baseline XYZ Shots"]
["5. Baseline Traverse"]
[null,"Approx. Length:",null,null,null,null,null,null,null,{"$f":"SUM(D26:I26)","v":0}]
["7. Compute Best-Fit Alignment (Graphically)"]
["   ","Approx. Length:",null,null,null,null,null,null,null,{"$f":"SUM(D28:I28)","v":0}]
["9. Establish/Elevate Temp. Bench Marks"]
[null,"No. of TBM's:",null,null,null,null,null,null,null,{"$f":"SUM(D30:I30)","v":0}]
["10. Pavement DTMs"]
[null,"Approx. Length:",null,null,null,null,null,null,null,{"$f":"SUM(D32:I32)","v":0}]
["11. Hydrographic Surveys & -T- Lines"]
[null,"Approx. Length:",null,null,null,null,null,null,null,{"$f":"SUM(D34:I34)","v":0}]
["12. Suppl. Info for DTM's (Obscured Areas)"]
[null,"No. of Acres / Hectares:",null,null,null,null,null,null,null,{"$f":"SUM(D36:I36)","v":0}]
["20. Loc. of Non-Gravity U/G Utilities"]
[null,"             (Dense, Med., or LT.):",null,null,null,null,null,null,null,{"$f":"SUM(D38:I38)","v":0}]
["21. Loc. of Gravity Utilities & Pipe Inverts"]
[null,"             (Dense, Med., or LT.):",null,null,null,null,null,null,null,{"$f":"SUM(D40:I40)","v":0},null,null,"…"]
["27. Production of Base Mapping"]
[null,"                           No. of Sheets:",null,null,null,null,null,null,null,{"$f":"SUM(D42:I42)","v":0}]
["28. GPS Points"]
[null,"                          No. of Points:",null,null,null,null,null,null,null,{"$f":"SUM(D44:I44)","v":0}]
["29. Misc. Staking"]
[null,"                          No. of Points:",null,null,null,null,null,null,null,{"$f":"SUM(D46:I46)","v":0},null,null,"…"]
["33. Travel ","Hrs R.T.",null,null,null,null,null,null,null,0]
["34. Project Mgmt. & Supervision",null,null,null,null,null,null,null,null,0]
["35. Traffic Control & Safety",null,null,null,null,null,null,null,null,0]
["MISCELLANEOUS",null,null,null,null,null,null,null,null,0]
["MISCELLANEOUS",null,null,null,null,null,null,null,null,0]
["MISCELLANEOUS",null,null,null,null,null,null,null,null,0]
["MISCELLANEOUS",null,null,null,null,null,null,null,null,0]
["MISCELLANEOUS",null,null,null,null,null,null,null,null,0]
[null,null,"TOTAL MANHOURS:",{"$f":"SUM(D21:D54)","v":0},{"$f":"SUM(E21:E54)","v":0},0,0,0,0,0]
[]
[null,"Classification",null,"Employee Name","Hours","Rate","Cost"]
["Project Engineer Manager",null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D44","v":0},{"$f":"D55","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E44","v":0},{"$f":"E58*F58","v":0}]
["Project Survey Supervisor",null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D45","v":0},{"$f":"E55","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E45","v":0},0,null,"TOTAL",null,"TOTAL DIRECT"]
["Advanced Survey Coordinator",null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D46","v":0},{"$f":"F55","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E46","v":0},0]
["Survey Crew Leader",null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D47","v":0},{"$f":"G55","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E47","v":0},0,null,"MANHOURS",null,"SALARY COSTS"]
["Assistant Survey Crew Leader",null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D48","v":0},{"$f":"H55","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E48","v":0},0,null,{"$f":"SUM(E58:E63)","v":0},null,{"$f":"SUM(G58:G63)","v":0}]
["Survey Crew Member",null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D49","v":0},{"$f":"I55","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E49","v":0},0]
[]
["INDIRECT SALARY COSTS"]
["Total Dir. Salary Costs",null,{"$f":"K62","v":0}]
["Overhead (XXX.XX%)",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F43","v":0},null,null,{"$f":"IF(NOT(C67=0),C66*(C67),)","v":0},null,null,null,null,{"$f":"SUM(C66,F67)","v":0}]
["Fee (%)",null,0.09,null,null,{"$f":"IF(NOT(C68=0),K67*(C68),)","v":0}]
["Cost of Capt. (X.XXXX%)",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G43","v":0},null,null,{"$f":"IF(NOT(C69=0),C66*(C69),)","v":0},null,null,null,null,"TOTAL DIR. and"]
[null,null,null,null,"Total Indirect Salary Costs:",{"$f":"SUM(F66:F69)","v":0},null,null,null,null,"INDIR. SALARY COSTS"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F67:F69,K62)","v":0}]
[]
["DIRECT COSTS"]
["Carry-all $/Day",{"$f":"50*B75","v":34.75},null,"Days = ",{"$f":"B74*C74","v":0}]
["or $/Mi",{"$f":"CARRYALL","v":0.69499999999999995},null,"Miles=",{"$f":"B75*C75","v":0}]
["Sedan       $/Day",{"$f":"50*B77","v":33.5},null,"Days =",{"$f":"B76*C76","v":0}]
["or $/ Mi",{"$f":"SEDAN","v":0.67},null,"Miles=",{"$f":"B77*C77","v":0}]
[null,null,null,"Misc. Survey Supplies=     ",null,null,null,null,null,null,"TOTAL DIRECT COSTS"]
["PER DIEM EXPENSES",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E74:E78)","v":0}]
["(Meals:",{"$f":"BREAKFAST+LUNCH+DINNER","v":46.5},"Max.; Lodging:",{"$f":"LODGING_COST.PLUS","v":89.1},"+ taxes; -- ",{"$f":"LODGING_LUMP.SUM","v":95},"for lump sum jobs)."]
[null,"$ / Day",{"$f":"LODGING_LUMP.SUM+BREAKFAST+LUNCH+DINNER","v":141.5},"x",null,"Persons",null,null,null,null,"TOTAL PER DIEM",null,null,null,null,"TOTAL DIRECT NON-SALARY COSTS"]
[null,null,null,null,null,null,"x",null,"Days = ",null,{"$f":"C81*E81*H82","v":0},null,null,null,null,{"$f":"K79+K82","v":0}]
[]
["Cost per Mi:",null,{"$f":"IF(NOT(SUM($C$13,$C$14,$I$13,$I$14)=0),$K$118/SUM($C$13,$C$14,$I$13,$I$14),\"\")","v":""},null,null,null,null,null,null,"             PROJECT ESTIMATE TOTAL:     ",{"$f":"SUM(K71,K79,K82)","v":0}]
["Manhours per Mi:",null,{"$f":"IF(NOT(SUM($C$13,$C$14,$I$13,$I$14)=0),$I$96/SUM($C$13,$C$14,$I$13,$I$14),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,"ESTIMATE BY:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OLD per diem numbers (July 01, 2012-June 30, 2013):"]
["(Meals: $36.35 Max., Lodging $63.90+ taxes - $71.50 for lump sum jobs)"]

{"sheet":"Geotechnical","index":11,"n_rows":135,"n_cols":19,"rows_kept":135,"cut":false,"hidden":true,"merged":[[2,2,2,15],[35,2,42,5],[45,2,48,4],[7,10,7,11],[62,2,62,3],[4,8,4,9],[15,3,15,13],[59,2,59,3],[64,2,64,3],[61,2,61,3],[60,2,60,3],[109,10,109,11],[82,10,82,11],[65,2,65,3],[63,2,63,3],[66,2,66,3],[121,6,121,7],[70,2,70,3],[69,2,69,3],[67,2,67,3],[68,2,68,3]]}
[]
[]
[null,null,"                              COST ESTIMATE FOR GEOTECHNICAL INVESTIGATIONS / STUDIES / RECOMMENDATIONS"]
[null,null,"  "]
[null,null,null,null,"              DATE:",null,null,"PEF NAME:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C51","v":0}]
[]
[null,null,"TIP:",null,"    COUNTY:",null,null,"                COMPILED BY:"]
[null,null,null,null,null,null,null,null,null,null,"NO. OF BENTS:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAFFIC CONTROL BY DIVISION -- YES=1 OR NO=0?"]
[null,null,"PROJECT DESCRIPTION:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAFFIC CONTROL BY PEF=1 OR SUBCONTRACTED=0?"]
[]
[]
[null,null,null,"MANHOURS BY CLASSIFICATION --> PER BENT"]
[null,null,"TASKS","TEM I","TES II","TE II","TEG II","TEG I","TT III CADD","TT III","TT II","TTA II","OA IV","OA III","MANHOURS PER BENT"]
[null,null,"FIELD WORK:"]
[null,null,"PER DIEM",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D19:N19)","v":0},{"$f":"O19/8","v":0}]
[null,null,"DRILLING",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D20:N20)","v":0},0]
[null,null,"FIELD PROFESSIONAL",null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"OFFICE WORK:",null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"INVENTORY PREP",null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"INVENTORY PREP",null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"FOUNDATION REC'S.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D25:N25)","v":0},0]
[null,null,"OTHERS (LIST):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D26:N26)","v":0},0]
[null,null,"TRAFFIC CONTROL (IF PROVIDED BY THE PEF).  (IF SUB-CONTRACTED, SEE BELOW).",null,null,null,null,null,null,null,null,{"$f":"IF(AND(O10=0,O13=1),H21, $D4:$P4)","v":0},null,null,{"$f":"SUM(D27:N27)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"TOTAL MANHOURS:",{"$f":"SUM(D19:D29)","v":0},0,0,0,0,0,{"$f":"SUM(J19:J29)","v":0},{"$f":"SUM(K19:K29)","v":0},{"$f":"SUM(L19:L29)","v":0},{"$f":"SUM(M19:M29)","v":0},{"$f":"SUM(N19:N29)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I31:R31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MANDAYS PER BENT",{"$f":"SUM(D30:N30)/8","v":0},"PER BENT"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MANDAYS",{"$f":"N32*M8","v":0}]
[null,null,"Total BRIDGE Manhours should include:\n1)  Bridge Report;\n2)  Bridge Spread and Deck Drain Analysis;\n3)  Pipes, Storm Drainage and Ditches;\n4)  CADD."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total PERMIT Manhours should include:\n1)  Stormwater Management Plan;\n2)  CADD."]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C4","v":"  "}]
[null,null,"Page 2 of 2","TIP:",{"$f":"D7","v":0},null,"Date:",{"$f":"F5","v":"00:00:00"}]
[]
[null,null,null,null,"GEOTECHNICAL INVESTIGATIONS / STUDIES / RECOMMENDATIONS"]
[]
[null,null,"I.  ENGINEERING SERVICES"]
[null,null,"  DIRECT SALARY COST:"]
[null,null,"Employee Name",null,"Classification","Hours","Hourly Raw Salary Rate","Cost",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F60:Q60)","v":0}]
[null,null,null,null,"TEM I",{"$f":"D30","v":0},null,{"$f":"F61*G61","v":0}]
[null,null,null,null,"TES II",{"$f":"E30","v":0},null,0]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D54","v":0},null,"TE II",{"$f":"F30","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E54","v":0},0,"PER BENT"]
[null,null,null,null,"TEG II",{"$f":"G30","v":0},null,0]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D56","v":0},null,"TEG I",{"$f":"H30","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E56","v":0},0,"PER BENT"]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D57","v":0},null,"TT III CADD",{"$f":"I30","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E57","v":0},0,"PER BENT"]
[null,null,null,null,"TT III",{"$f":"J30","v":0},null,0]
[null,null,null,null,"TT II",{"$f":"K30","v":0},null,0]
[null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D60","v":0},null,"TTA II",{"$f":"L30","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E60","v":0},0,"PER BENT"]
[null,null,null,null,"OA IV",{"$f":"M30","v":0},null,0]
[null,null,null,null,"OA III",{"$f":"N30","v":0},null,0]
[null,null,null,null,"TOTAL MANHOURS",{"$f":"SUM(F61:F71)","v":0}]
[null,null,null,null,"TOTAL MANDAYS",{"$f":"F72/8","v":0}]
[]
[null,null,null,null,"TOTAL DIRECT SALARY COST:",null,null,{"$f":"SUM(H61:H71)","v":0}]
[null,null,null,null,"OVERHEAD (XXX.XX%):",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F51","v":0},{"$f":"H75*G76","v":0}]
[null,null,null,null,"SUBTOTAL:",null,0,{"$f":"SUM(H75:H76)","v":0}]
[null,null,null,null,"FIXED FEE",null,0.09,{"$f":"G78*(H77)","v":0}]
[null,null,null,null,"COST OF CAPITAL (X.XXXX%):",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G51","v":0},{"$f":"H75*G79","v":0}]
[]
[null,null,null,null,null,null,"SUB-TOTAL DIRECT AND INDIRECT SALARY COST:",{"$f":"SUM(H77:H79)","v":0},"PER BENT"]
[]
[null,null,null,null,null,null,null,null,null,null,"NO. OF BENTS:",null,{"$f":"M8","v":0}]
[null,null,"(1)      Group positions by general classifications;  Project Manager, "]
[null,null,"          Project Engineer, Design Engineer, Senior Technician, Tech./Draft"]
[null,null,"(2)     Maximum billing rates for classifications:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT AND INDIRECT SALARY COST:",{"$f":"H81*M83","v":0}]
[null,null,"                 Project Manager                              $118.10/hr."]
[null,null,"                 Project Engineer                              $92.16/hr."]
[null,null,"                 Design Engineer                              $76.04/hr."]
[null,null,"                 Senior Technician                            $64.76/hr."]
[null,null,"                      Tech/Draft                                        $53.35/hr."]
[]
[]
[]
[]
[null,null,"II.  DIRECT COSTS"]
[null,null,"(BASED ON \"TEG I -- FIELD WORK\" TIME ABOVE)."]
[]
[null,null,"DRILLING:  (INCLUDES DRILL RIG COST)",null,null,11.5,"(per foot) X",120,"(feet PER BENT) =",{"$f":"IF(O21=0,\" \",F100*H100)","v":" "},"PER BENT","$/foot and Footage per bent are based on Statewide"]
[null,null,null,null,null,null,null,null,null,null,null,"Averages for ARRA projects and includes"]
[null,null,null,null,null,null,null,"(I.E.  EAST=120 FT. @ 1 HOLE PER BENT; WEST=120 FT. @ 2 HOLES PER BENT)",null,null,null,"SPT Drilling; or Rock Drilling and Casing."]
[]
[null,null,"PER DIEM EXPENSE:"]
[null,null,null,null,null,{"$f":"LODGING_LUMP.SUM+BREAKFAST+LUNCH+DINNER","v":141.5},"(per day) X",3,"Person-Days* =",{"$f":"IF(O21=0,\" \",F105*H105)","v":" "},"PER BENT","* 1 Person-Day = 1 Person for 1 Day."]
[null,null,null,null,null,null,null,null,null,null,null,"Therefore:  Drill Crew Per Diem is for 3 people for 1 day."]
[]
[null,null,null,null,null,null,"SUB-TOTAL DIRECT AND INDIRECT SALARY COST:",null,null,{"$f":"SUM(J100,J105)","v":0},"PER BENT"]
[]
[null,null,null,null,null,null,null,null,null,null,"NO. OF BENTS:",null,{"$f":"M8","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT COSTS:",{"$f":"J108*M110","v":0}]
[]
[]
[null,null,"III.  MOBILIZATION; and TRAFFIC CONTROL (if subcontracted)"]
[]
[]
[null,null,"MOBILIZATION:",null,3.3,"(per mile) X",300,"Miles =",{"$f":"IF(O21=0,\" \",E120*G120)","v":" "},"TOTAL PER PROJECT"]
[]
[null,null,"TRAFFIC CONTROL:",null,1500,"(PER DAY)","NO. OF DAYS DRILLING (ALL BENTS)",null,{"$f":"M8*O21/8","v":0},{"$f":"IF(AND(O10=0,O13=0),E122*I122, $D4:$P4)","v":0},"TOTAL PER PROJECT",null,"If Traffic Control is performed by the PEF"]
[null,null,"(IF SUBCONTRACTED)",null,null,null,null,null,null,null,null,null,"use TTA II time above."]
[]
[]
[]
[null,null,"IV.  SUMMARY"]
[]
[null,null,"     ENGINEERING SERVICES",null,null,null,{"$f":"N87","v":0}]
[null,null,"     DIRECT COSTS",null,null,null,{"$f":"N114","v":0},null,{"$f":"G129+G130","v":0},"\"ALL BENTS TOTAL\"",null,null,{"$f":"SUM(H81,J108)","v":0},"TOTAL PER BENT COST"]
[null,null,"     MOBILIZATION; and TRAFFIC CONTROL (if subcontracted)",null,null,null,{"$f":"SUM(I120,J122)","v":0}]
[]
[]
[]
[null,null,"    PROJECT ESTIMATE TOTAL:",null,null,null,{"$f":"SUM(G129:G131)","v":0}]

{"sheet":"Utilities--Coord & Design","index":12,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":true,"merged":[[38,0,38,13],[40,2,40,8],[40,9,40,13],[65,2,65,8],[61,4,61,8],[60,4,60,8],[63,4,63,8],[39,4,39,8],[39,9,39,13],[51,4,51,8],[52,2,52,8],[51,9,51,13],[52,9,52,13],[58,9,58,13],[59,4,59,8],[59,9,59,13],[73,1,73,8],[83,1,83,3],[83,4,83,5],[83,6,83,10],[42,9,42,13],[43,4,43,8],[43,9,43,13],[44,9,44,13],[45,4,45,8],[45,9,45,13],[64,9,64,13],[56,4,56,8],[56,9,56,13],[57,4,57,8],[47,9,47,13],[48,4,48,8],[48,9,48,13],[49,4,49,8],[49,9,49,13],[50,9,50,13],[66,4,66,8],[67,4,67,8],[60,9,60,13],[55,9,55,13],[66,9,66,13],[67,9,67,13],[41,4,41,8],[42,4,42,8],[44,4,44,8],[47,4,47,8],[50,4,50,8],[55,4,55,8],[41,9,41,13],[46,4,46,8],[46,9,46,13],[53,4,53,8],[53,9,53,13],[54,4,54,8],[54,9,54,13],[57,9,57,13],[58,2,58,8],[61,9,61,13],[62,9,62,13],[65,9,65,13],[62,2,62,8],[63,9,63,13],[64,4,64,8],[33,0,33,4],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[0,4,0,6],[0,7,0,8],[5,5,5,6],[5,7,5,8],[5,1,5,4],[6,7,6,8],[0,2,0,3],[2,2,2,3],[2,7,2,8],[1,2,1,3],[23,8,24,8],[21,6,21,7],[23,6,24,7],[20,0,20,1],[24,0,24,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[1,4,1,6],[1,7,1,8],[19,6,19,7],[4,4,4,6],[11,4,11,5],[9,0,9,3],[9,4,9,8],[10,1,10,3],[8,0,8,1],[8,2,8,4],[6,1,6,4],[6,5,6,6],[4,7,4,8],[19,0,19,1],[10,4,10,5],[10,6,10,8],[11,6,11,8],[11,1,11,3]]}
["Project ","TIP",null,null,"Purchase Order Contract #"]
[null,"County",null,null,"Limited Services Agreement",null,null,"N/A"]
[null,"WBS PE",null,null,null,null,"WBS RW"]
[]
["PEF"]
["Name",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C64","v":0},null,null,null,"Firm's Contract ID"]
["Project Contact",null,null,null,null,"Contract official"]
[]
["NCDOT Project Contacts"]
["Engineering",null,null,null,"Coordination"]
["Ut Eng Squad Leader",null,null,null,"UCU Area Coordinator"]
["Ut Engineer",null,null,null,"UCU Coordinator"]
[]
["Project Estimate","Principal or Project Engineer or TES III","Project Design Engineer or TES II","Senior Engineer or TE II","Junior Engineer or TE I","Senior Technician or TT IV","Junior Technician or TT II",null,"SubTotal"]
["Employee Name",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D65","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D66","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D67","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D68","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D69","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D70","v":0}]
["Manhours",{"$f":"B81","v":0},{"$f":"C81","v":0},0,0,0,0,0,{"$f":"SUM(B16:H16)","v":0}]
["Hourly Rate",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E65","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E66","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E67","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E68","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E69","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E70","v":0}]
["SubTotal",{"$f":"B16*B17","v":0},0,0,0,0,0,0,{"$f":"SUM(B18:H18)","v":0}]
[null,null,null,null,null,null,"Overhead",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F64","v":0},{"$f":"I18*H19","v":0}]
["Invoicing Percentages",null,"Manhours","% Work",null,null,"Subtotal",null,{"$f":"I18+I19","v":0}]
[{"$f":"A76","v":"UAPR"},null,{"$f":"I76","v":0},{"$f":"IF(C$26=0,0,C21/C$26)","v":0},null,null,"Fee",0.09,{"$f":"I20*H21","v":0}]
[{"$f":"A77","v":"Utility Construction"},null,{"$f":"I77","v":0},{"$f":"IF(C$26=0,0,C22/C$26)","v":0},null,null,"Direct Costs",null,{"$f":"L93","v":0}]
[{"$f":"A78","v":"Utilities by Others"},null,{"$f":"I78","v":0},{"$f":"IF(C$26=0,0,C23/C$26)","v":0},null,null,"CoC",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G64","v":0},{"$f":"I18*H23","v":0}]
[{"$f":"A79","v":"Not Included"},null,{"$f":"I79","v":0},{"$f":"IF(C$26=0,0,C24/C$26)","v":0},null,null,"Total Cost",null,{"$f":"I20+I21+I22+I23","v":0}]
[{"$f":"A80","v":"Not Included"},null,{"$f":"I80","v":0},{"$f":"IF(C$26=0,0,C25/C$26)","v":0}]
[null,"Total",{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D21:D25)","v":0}]
[]
["Product",null,"Draft Submittal","UC Ag Plans","95% Submittal","Final Submittal"]
[{"$f":"A21","v":"UAPR"}]
[{"$f":"A22","v":"Utility Construction"}]
[{"$f":"A23","v":"Utilities by Others"}]
[{"$f":"A24","v":"Not Included"}]
[{"$f":"A25","v":"Not Included"}]
["Dates are latest that the overall activity can occur. "]
[]
[]
[]
[]
[{"$f":"\"Project \" & C1 & \" \" & C2","v":"Project  "}]
["Phase","Include in estimate","Product","Include in estimate","Activity",null,null,null,null,"Project Specific Details"]
[1,"Yes","UAPR"]
[null,null,null,"Yes","Draft Utility Analysis",null,null,null,null,"Identifying project utiity conflicts"]
[null,null,null,"Yes","Data Collection",null,null,null,null,"From Utility Owners"]
[null,null,null,"No","Conflict Mitigation",null,null,null,null,"Using Alternate Design Approach"]
[null,null,null,"No","Identify SUE Needs/Requirements",null,null,null,null,"Provide to NCDOT for execution through L&S"]
[null,null,null,"Yes","Preliminary routing",null,null,null,null,"Proposed relocations and constructability"]
[null,null,null,"No","Identification of ROW/PUE requirements",null,null,null,null,"Provide to NCDOT for execution through ROW"]
[null,null,null,"Yes","Preparation of cost estimate"]
[null,null,null,"Yes","Obtaining utility owner concurrence for proposed utility relocations",null,null,null,null,"Schedule, design responsibility, who moves, and obtains general agreement with a plan of action."]
[null,null,null,"Yes","Provide Final UAPR Report to NCDOT & Utility Owner(s)",null,null,null,null,"Hard Copies"]
[null,null,null,"Yes","Furnish final electronic files for inclusion in the project file",null,null,null,null,"Microstation/Microsoft Word/Excel (latest version)"]
[]
[2,"Yes","Utility Construction"]
[null,null,null,"Yes","Assisting the utility owner in developing final UC plans and provisions",null,null,null,null,"Coordinated through NCDOT and Utility Owner"]
[null,null,null,"Yes","Coordinating all design reviews with the owner and acknowledgement of the final acceptance of plans and provisions",null,null,null,null,"Coordination through Agencies only if specifically required for this project"]
[null,null,null,"Yes","Providing final design package to NCDOT for incorporation into the proposal documents",null,null,null,null,"To Utilities Encroachment & Engineering Unit"]
[null,null,null,"Yes","Furnish final electronic files for inclusion in the project file",null,null,null,null,"Microstation (latest version)"]
[null,null,null,"Yes","Water and Sewer Permits for DENR Approval",null,null,null,null,"Plan, Provisions, and permit application to DENR"]
[3,"Yes","Utilities by Others"]
[null,null,null,"No","Assist Utility Owners in Development of Relocation Plans",null,null,null,null,"Using Final UAPR plans"]
[null,null,null,"Yes","Provide UbO plans and provisions to NCDOT",null,null,null,null,"Electronic files to be provided"]
[]
[4,"no","Environmental Permit Drawings"]
[null,null,null,"no","Permit drawings for impacts by utility relocations"]
[null,null,null,"no","Permit drawings for CAMA permit",null,null,null,null,"requires profiles"]
[null,"no","Other"]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Project \" & C1 & \" \" & C2","v":"Project  "},"Manhours"]
["Activity",{"$f":"B14","v":"Principal or Project Engineer or TES III"},{"$f":"C14","v":"Project Design Engineer or TES II"},"Senior Engineer or TE II","Junior Engineer or TE I","Senior Technician or TT IV","Junior Technician or TT II",0,"Sub-total"]
[{"$f":"IF(B41=\"yes\",C41,IF(B41=\"No\",\"Not Included\", \"undecided\"))","v":"UAPR"},null,null,null,null,null,null,null,{"$f":"SUM(B76:H76)","v":0}]
[{"$f":"IF(B53=\"yes\",C53,IF(B53=\"No\",\"Not Included\", \"undecided\"))","v":"Utility Construction"},null,null,null,null,null,null,null,{"$f":"SUM(B77:H77)","v":0}]
[{"$f":"IF(B59=\"yes\",C59,IF(B59=\"No\",\"Not Included\", \"undecided\"))","v":"Utilities by Others"},null,null,null,null,null,null,null,{"$f":"SUM(B78:H78)","v":0}]
[{"$f":"IF(B63=\"yes\",C63,IF(B63=\"No\",\"Not Included\", \"undecided\"))","v":"Not Included"},null,null,null,null,null,null,null,{"$f":"SUM(B79:H79)","v":0}]
[{"$f":"IF(B66=\"yes\",C66,IF(B66=\"No\",\"Not Included\", \"undecided\"))","v":"Not Included"},null,null,null,null,null,null,null,{"$f":"SUM(B80:H80)","v":0}]
["Totals",{"$f":"B76+B77+B78+B79+B80","v":0},0,0,0,0,0,0,0]
[]
["Direct Costs"]
[null,"Paper copies",null,null,"Misc.",null,"Travel"]
[{"$f":"A75","v":"Activity"},"8-1/2\"x11\"","11\"x17\"","Bond (34\"x22\")","Postage and Fax","Film and Developing","Breakfast","Lunch","Supper","Overnight per Diem","Mileage","Subtotals"]
["UAPR",null,null,null,null,null,null,null,null,null,null,{"$f":"B86*B$92+C86*C$92+D86*D$92+E86+F86*F$92+G86*G$92+H86*H$92+I86*I$92+J86*J$92+K86*K$92","v":0}]
["Utility Construction",null,null,null,null,null,null,null,null,null,null,0]
["Utilities by Others",null,null,null,null,null,null,null,null,null,null,0]
["Not Included",null,null,null,null,null,null,null,null,null,null,0]
["Not Included",null,null,null,null,null,null,null,null,null,null,0]
["Totals",{"$f":"SUM(B86:B90)","v":0},{"$f":"SUM(C86:C90)","v":0},{"$f":"SUM(D86:D90)","v":0},null,{"$f":"SUM(F86:F90)","v":0},0,0,0,0,0,0]
["Rate",{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"LEDGERCOPIES","v":0.34},{"$f":"BOND.REGULAR","v":0.42},null,{"$f":"FILM","v":20},{"$f":"BREAKFAST","v":10.1},{"$f":"LUNCH","v":13.3},{"$f":"DINNER","v":23.1},{"$f":"LODGING_LUMP.SUM","v":95},{"$f":"SEDAN","v":0.67},"Total"]
["Costs",{"$f":"B91*B92","v":0},{"$f":"C91*C92","v":0},{"$f":"D91*D92","v":0},{"$f":"SUM(E86:E90)","v":0},{"$f":"F91*F92","v":0},0,0,0,0,0,{"$f":"SUM(B93:K93)","v":0}]

{"sheet":"Right of Way","index":13,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":true,"merged":[[23,0,23,7],[0,0,0,2],[0,3,0,6],[2,0,2,2],[2,3,2,6]]}
["Contract Prime PEF:"]
[]
["Sub-Consultant:"]
[]
["Classification",null,null,"Parcels","* Rate (w/o Appraisals)","* Rate (w/ Appraisals)","Cost"]
[null,null,null,null,2800,null,{"$f":"D6*E6","v":0}]
[null,null,null,null,null,4000,{"$f":"D7*F7","v":0}]
[]
[null,"Total Direct Salary",null,null,{"$f":"SUM(G6:G7)","v":0}]
[null,"Overhead Rate ",null,0,"N/A"]
[null,"Sub-Total 1",null,null,{"$f":"SUM(E9:E10)","v":0}]
[null,"Fee",null,"N/A","N/A"]
[null,"Cost of Capital",null,0,"N/A"]
[null,"Total Salary Costs",null,null,{"$f":"SUM(E11:E13)","v":0}]
[null,"Direct Costs",null,null,"N/A"]
[null,"Total Salary & Direct Costs",null,null,{"$f":"SUM(E14:E15)","v":0}]
[]
[]
[]
[null,"*  Rate per parcel includes all Overhead, Fee (Profit), Cost of Capital, and Direct Costs."]

{"sheet":"PDEA","index":14,"n_rows":162,"n_cols":23,"rows_kept":162,"cut":false,"hidden":true,"merged":[[66,1,66,2],[4,16,8,16],[1,9,1,10],[89,1,89,3],[75,1,76,2],[89,6,89,7],[86,1,86,7],[87,1,87,3],[4,9,8,9],[4,11,8,11],[67,1,67,2],[88,1,88,3],[88,6,88,7],[75,3,76,4],[71,1,71,2],[73,1,73,2],[55,1,55,2],[57,1,57,2],[4,15,8,15],[4,12,8,12],[4,13,8,13],[4,14,8,14],[4,3,8,3],[4,4,8,4],[4,5,8,5],[4,6,8,6],[4,7,8,7],[4,8,8,8],[4,10,8,10],[69,1,69,2],[0,1,0,6],[2,0,3,22],[60,1,60,2],[63,1,63,2],[64,1,64,2],[54,1,54,2],[58,1,58,2],[62,1,62,2],[61,1,61,2],[0,8,0,10],[0,21,0,22],[1,21,1,22],[0,17,0,18],[65,1,65,2],[0,13,0,14]]}
["PROJECT DESCRIPTION:",null,null,null,null,null,null,"FIRM:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C72","v":0},null,null,null,"TASK ORDER NUMBER:",null,null,null,"WBS NUMBER:",null,null,null,"DATE PREPARED:"]
["PREPARED BY: ",null,null,null,null,null,null,null,"TIP NUMBER:",null,null,null,null,null,null,null,null,null,null,null,"REVISION DATE:"]
["ENVIRONMENTAL BREAKDOWN WORKSHEET"]
[]
[null,null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C73","v":"BRANCH MAN.(TD-1)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C74","v":"UNIT HEAD(TM-1)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C75","v":"GROUP MAN.(TES-3)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C76","v":"PROJ. ENG.(TE-3)(TE-2)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C77","v":"DRAFT& REPO.TECH.(TT-2)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C78","v":"COMM.PLNR(CP-2)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C79","v":"ENV.SPVR./ENGR.(TE-3)(ES-3)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C80","v":"ENV.SPEC.(ES-3)(ES-2)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C81","v":"ARCH. & HISTORIC SPVR."},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C82","v":"ARCH. & HISTORIC SPEC. (ARCH-2)(HPRS-2)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C83","v":"TRANS.ENG.SPVR.(TE-3))"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C84","v":"TRANS.ENG.(TE-1)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C85","v":"ENV.TECH 3 (TT-3)"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C86","v":"WORD.PROC.SPVR.(WP-2)"},"ROADWAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESIGN","HYDRAULIC","SUB-","%","PEF","%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRANCH","BRANCH","TOTAL","OF","ESTIMATE","OF"]
["TASK","TASK DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLENDED","BLENDED",null,"PROJECT",null,"PROJECT"]
["NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RATE","RATE"]
[1,"SCOPING"]
[null,"     Field Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D11:S11)","v":0},{"$f":"IF(T11>0,T11/$T$61,\"\")","v":""},null,{"$f":"IF(V11>0,V11/$V$61,\"\")","v":""}]
[null,"     Field Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D12:S12)","v":0},{"$f":"IF(T12>0,T12/$T$61,\"\")","v":""},null,{"$f":"IF(V12>0,V12/$V$61,\"\")","v":""}]
[null,"     Review Scope of Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:S13)","v":0},{"$f":"IF(T13>0,T13/$T$61,\"\")","v":""},null,{"$f":"IF(V13>0,V13/$V$61,\"\")","v":""}]
[null,"     Estimates & Negotiations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:S14)","v":0},{"$f":"IF(T14>0,T14/$T$61,\"\")","v":""},null,{"$f":"IF(V14>0,V14/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T15>0,T15/$T$61,\"\")","v":""},null,{"$f":"IF(V15>0,V15/$V$61,\"\")","v":""}]
[2,"PLANNING"]
[null,"     Vicinity Map (Figure 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:S17)","v":0},{"$f":"IF(T17>0,T17/$T$61,\"\")","v":""},null,{"$f":"IF(V17>0,V17/$V$61,\"\")","v":""}]
[null,"     Pre-scoping Letter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,"     NRTR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,"     Community Impact Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,"     Hydrographic Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,"     Preliminary Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,"          - Figure 2, Figure 3, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[3,"SECTION 106"]
[null,"     Architecture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D26:S26)","v":0},{"$f":"IF(T26>0,T26/$T$61,\"\")","v":""},null,{"$f":"IF(V26>0,V26/$V$61,\"\")","v":""}]
[null,"     Archaeology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D27:S27)","v":0},{"$f":"IF(T27>0,T27/$T$61,\"\")","v":""},null,{"$f":"IF(V27>0,V27/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T28>0,T28/$T$61,\"\")","v":""},null,{"$f":"IF(V28>0,V28/$V$61,\"\")","v":""}]
[4,"COORDINATION"]
[null,"      Progress Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:S30)","v":0},{"$f":"IF(T30>0,T30/$T$61,\"\")","v":""},null,{"$f":"IF(V30>0,V30/$V$61,\"\")","v":""}]
[null,"     Other Meetings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D31:S31)","v":0},{"$f":"IF(T31>0,T31/$T$61,\"\")","v":""},null,{"$f":"IF(V31>0,V31/$V$61,\"\")","v":""}]
[null,"     Project Coordination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D32:S32)","v":0},{"$f":"IF(T32>0,T32/$T$61,\"\")","v":""},null,{"$f":"IF(V32>0,V32/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T33>0,T33/$T$61,\"\")","v":""},null,{"$f":"IF(V33>0,V33/$V$61,\"\")","v":""}]
[5,"SECTION 7"]
[null,"     Meetings (Field / Local)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D35:S35)","v":0},{"$f":"IF(T35>0,T35/$T$61,\"\")","v":""},null,{"$f":"IF(V35>0,V35/$V$61,\"\")","v":""}]
[null,"     Additional Design & Graphics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D36:S36)","v":0},{"$f":"IF(T36>0,T36/$T$61,\"\")","v":""},null,{"$f":"IF(V36>0,V36/$V$61,\"\")","v":""}]
[null,"     Coordination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:S37)","v":0},{"$f":"IF(T37>0,T37/$T$61,\"\")","v":""},null,{"$f":"IF(V37>0,V37/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T38>0,T38/$T$61,\"\")","v":""},null,{"$f":"IF(V38>0,V38/$V$61,\"\")","v":""}]
[6,"SECTION 4(f)"]
[null,"     Determination Meeting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:S40)","v":0},{"$f":"IF(T40>0,T40/$T$61,\"\")","v":""},null,{"$f":"IF(V40>0,V40/$V$61,\"\")","v":""}]
[null,"     Programmatic 4(f)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D41:S41)","v":0},{"$f":"IF(T41>0,T41/$T$61,\"\")","v":""},null,{"$f":"IF(V41>0,V41/$V$61,\"\")","v":""}]
[null,"     Formal 4(f)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D42:S42)","v":0},{"$f":"IF(T42>0,T42/$T$61,\"\")","v":""},null,{"$f":"IF(V42>0,V42/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T43>0,T43/$T$61,\"\")","v":""},null,{"$f":"IF(V43>0,V43/$V$61,\"\")","v":""}]
[7,"PUBLIC INVOLVEMENT"]
[null,"     Newsletter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D45:S45)","v":0},{"$f":"IF(T45>0,T45/$T$61,\"\")","v":""},null,{"$f":"IF(V45>0,V45/$V$61,\"\")","v":""}]
[null,"     Prepare for CIW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D46:S46)","v":0},{"$f":"IF(T46>0,T46/$T$61,\"\")","v":""},null,{"$f":"IF(V46>0,V46/$V$61,\"\")","v":""}]
[null,"     CIW / Local Officials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:S47)","v":0},{"$f":"IF(T47>0,T47/$T$61,\"\")","v":""},null,{"$f":"IF(V47>0,V47/$V$61,\"\")","v":""}]
[null,"          - Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:S48)","v":0},{"$f":"IF(T48>0,T48/$T$61,\"\")","v":""},null,{"$f":"IF(V48>0,V48/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T49>0,T49/$T$61,\"\")","v":""},null,{"$f":"IF(V49>0,V49/$V$61,\"\")","v":""}]
[8,"ENVIRONMENTAL DOCUMENT"]
[null,"     Prepare Draft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:S51)","v":0},{"$f":"IF(T51>0,T51/$T$61,\"\")","v":""},null,{"$f":"IF(V51>0,V51/$V$61,\"\")","v":""}]
[null,"     Revise & Finalize",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D52:S52)","v":0},{"$f":"IF(T52>0,T52/$T$61,\"\")","v":""},null,{"$f":"IF(V52>0,V52/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T53>0,T53/$T$61,\"\")","v":""},null,{"$f":"IF(V53>0,V53/$V$61,\"\")","v":""}]
[9,"MISCELLANEOUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D55:S55)","v":0},{"$f":"IF(T55>0,T55/$T$61,\"\")","v":""},null,{"$f":"IF(V55>0,V55/$V$61,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D56:S56)","v":0},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:S57)","v":0},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D58:S58)","v":0},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D59:S59)","v":0},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,"TOTAL WORKDAYS/CATEGORY:",null,{"$f":"SUM(D11:D60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D61:S61)","v":0},{"$f":"SUM(U11:U52)","v":0},0,{"$f":"SUM(W11:W52)","v":0}]
[null,"EMPLOYEE NAME:",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D73","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D74","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D75","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D76","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D77","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D78","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D79","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D80","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D81","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D82","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D83","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D84","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D85","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D86","v":0}]
[null,"HOURLY SALARY RATE:",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E73","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E74","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E75","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E76","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E77","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E78","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E79","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E80","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E81","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E82","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E83","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E84","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E85","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E86","v":0}]
[null,"RATES PER DAY:",null,{"$f":"D63*8","v":0},{"$f":"E63*8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PAYROLL BURDEN:",null,{"$f":"SUM(D61*D64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL WORKDAYS:",null,{"$f":"SUM(D61:S61)","v":0}]
[null,"TOTAL PAYROLL BURDEN:",null,{"$f":"SUM(D65:S65)","v":0}]
[null,"AVERAGE COST PER HOUR:",null,{"$f":"IF(D66<>0,SUM(D67/D66)/8,0)","v":0}]
[null,"GENERAL OVERHEAD (AS A PERCENTAGE xxx.xx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F72","v":0},{"$f":"SUM(D67*C69)","v":0}]
[null,"SUBTOTAL:",null,{"$f":"SUM(D67+D69)","v":0}]
[null,"COMPARATIVE FEE @",0.09,{"$f":"SUM(D70*C71)","v":0}]
[null,"TOTAL:",null,{"$f":"SUM(D70:D71)","v":0}]
[null,null,"DIRECT EXPENSES @",{"$f":"H162","v":0}]
[null,"SUBCONSULTANT FEES:",null,0]
[null,"FACILITIES COST OF CAPITAL (AS A PERCENTAGE x.xxxx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G72","v":0},{"$f":"D67*C75","v":0}]
[null,"TOTAL:",null,{"$f":"SUM(D72:D75)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["DIRECT EXPENSES"]
[]
["PROJECT\nDESCRIPTION: "]
["PREPARED BY:"]
["TIP NUMBER: ",null,null,null,"PROJECT NUMBER: "]
["DATE PREPARED:  ",null,null,null,"REVIEWED BY UNIT HEAD ON:"]
[]
[null,"Travel:"]
[null,"Sedan",0,"Trip(s) @",0,"miles @",{"$f":"SEDAN","v":0.67},{"$f":"SUM(C93*E93*G93)","v":0}]
[null,"Carry All",0,"Trip(s) @",0,"miles @",{"$f":"CARRYALL","v":0.69499999999999995},{"$f":"SUM(C94*E94*G94)","v":0}]
[null,"Car Rental",null,null,0,"days @ ",{"$f":"CARRENTAL","v":50},{"$f":"SUM(E95*G95)","v":0}]
[null,"Gas for Rental",null,null,0,"miles @",{"$f":"GASforRENTAL","v":0.2},{"$f":"E96*G96","v":0}]
[null,"Parking:",null,"Trip(s) @",null,null,{"$f":"PARKING","v":3},{"$f":"SUM(C97*G97)","v":0}]
[null,"Per Diem:",0,"Breakfast",null,null,{"$f":"BREAKFAST","v":10.1},0]
[null,null,0,"Lunch",null,null,{"$f":"LUNCH","v":13.3},0]
[null,null,0,"Dinner",null,null,{"$f":"DINNER","v":23.1},0]
[null,null,0,"Lodging (Including taxes)",null,null,{"$f":"LODGING_LUMP.SUM","v":95},0]
[null,"Reproduction:",0,"8 1/2 x 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},0]
[null,null,0,"11 x 17 Copy (s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},0]
[null,null,0,"Cover(s) @",null,null,{"$f":"COVERS","v":0.5},0]
[null,null,0,"Binder(s) @",null,null,{"$f":"BINDERS","v":0.5},0]
[null,null,0,"Color Copy(s) @",null,null,{"$f":"LETTERCOLOR","v":0.83},0]
[null,null,0,"Blueline(s) @",null,null,{"$f":"BLUEPRINTSLETTER","v":0.35},0]
[null,"Film and Developing:",0,"Roll(s) @",null,null,{"$f":"FILM","v":20},0]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H92:H108)","v":0}]
[]
[null,"Maps & Documents:"]
[null,"County Tax Maps:",0,"Map(s) @",null,null,{"$f":"County_Tax_Maps","v":7},{"$f":"SUM(C112*G112)","v":0}]
[null,"USGS Maps:",0,"Map(s) @",null,null,{"$f":"USGSMAPS","v":7},{"$f":"SUM(C113*G113)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H112:H113)","v":0}]
[]
[null,"Technical Reports"]
[null,"Reproduction:",0,"8 1/2 X 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C117*G117)","v":0}]
[null,null,0,"11 x 17 Copy(s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},{"$f":"SUM(C118*G118)","v":0}]
[null,null,0,"Blueline(s) @",null,null,{"$f":"BLUEPRINTSLETTER","v":0.35},{"$f":"SUM(C119*G119)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H117:H119)","v":0}]
[]
[null,"Design"]
[null,"Reproduction:",0,"8 1/2 x 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C123*G123)","v":0}]
[null,null,0,"11 x 17 Copy(s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},0]
[null,null,0,"Blueline(s) @",null,null,{"$f":"BLUEPRINTSLETTER","v":0.35},0]
[null,null,0,"Mylar Sepia(s) @",null,null,{"$f":"MYLARSLETTER","v":7.32},0]
[null,null,0,"Cross-Sections Sheet(s)",null,null,{"$f":"BOND.LARGE","v":3.5},0]
[null,null,0,"Enlarge Quad Map(s)",null,null,50,0]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H123:H128)","v":0}]
[]
[null,"Environmental Document"]
[null,"Reproduction:",0,"8 1/2 x 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C132*G132)","v":0}]
[null,null,0,"11 x 17 Copy(s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},{"$f":"SUM(C133*G133)","v":0}]
[" ",null,0,"Cover(s) @",null,null,{"$f":"COVERS","v":0.5},{"$f":"SUM(C134*G134)","v":0}]
[null,null,0,"Binder(s) @",null,null,{"$f":"BINDERS","v":0.5},{"$f":"SUM(C135*G135)","v":0}]
[null,null,0,"Color Copy(s) @",null,null,{"$f":"LETTERCOLOR","v":0.83},{"$f":"SUM(C136*G136)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H132:H136)","v":0}]
[]
[null,"MEETINGS & PUBLIC INVOLVEMENT"]
[null,"Travel:"]
[null,"Sedan",0,"Trip(s) @",0,"miles @",{"$f":"SEDAN","v":0.67},{"$f":"SUM(C141*E141*G141)","v":0}]
[null,"CarryAll",0,"Trip(s) @",0,"miles @",{"$f":"CARRYALL","v":0.69499999999999995},{"$f":"SUM(C142*E142*G142)","v":0}]
[null,"Car Rental",null,null,0,"days @",{"$f":"CARRENTAL","v":50},{"$f":"SUM(E143*G143)","v":0}]
[null,"Gas for Rental",null,null,0,"miles @",{"$f":"GASforRENTAL","v":0.2},{"$f":"SUM(E144*G144)","v":0}]
[null,"Parking:",0,"Trip(s) @",null,null,{"$f":"PARKING","v":3},{"$f":"SUM(C145*G145)","v":0}]
[null,"Per Diem:",0,"Breakfast",null,null,{"$f":"BREAKFAST","v":10.1},{"$f":"SUM(C146*G146)","v":0}]
[null,null,0,"Lunch",null,null,{"$f":"LUNCH","v":13.3},{"$f":"SUM(C147*G147)","v":0}]
[null,null,0,"Dinner",null,null,{"$f":"DINNER","v":23.1},{"$f":"SUM(C148*G148)","v":0}]
[null,null,0,"Lodging (Including taxes)",null,null,{"$f":"LODGING_LUMP.SUM","v":95},{"$f":"SUM(C149*G149)","v":0}]
[null,"Workshop Handouts"]
[null,"  - Reproduction",0,"8 1/2 x 11 Page(s) @",0,"Handouts",{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C151*G151)","v":0}]
[null,null,0,"11 x 17 Page(s) @",0,"Handouts",{"$f":"LEDGERCOPIES","v":0.34},{"$f":"SUM(C152*E152*G152)","v":0}]
[null,"Presentation Materials:"]
[null,"  - Public Officials Meetings:",0,"Meeting(s) @",null,null,50,{"$f":"SUM(C154*G154)","v":0}]
[null,"  - Public Workshops:",0,"Workshop(s) @",null,null,200,{"$f":"SUM(C155*G155)","v":0}]
[null,"  - Slide Presentation:",0,"Presentation @",null,null,350,{"$f":"SUM(C156*G156)","v":0}]
[null,"Mailing Labels:",0,"Box(s) @",null,null,37,{"$f":"SUM(C157*G157)","v":0}]
[null,"Postage:"]
[null,"  - Public Workshops:",0,"Workshop(s) @",0,"copies @",{"$f":"POSTAGE","v":0.49},{"$f":"SUM(C159*E159*G159)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H140:H159)","v":0}]
[]
[null,null,null,null,null,"TOTAL",null,{"$f":"SUM(H109+H114+H120+H129+H137+H160)","v":0}]

{"sheet":"MISCELLANEOUS","index":15,"n_rows":231,"n_cols":23,"rows_kept":231,"cut":false,"hidden":true,"merged":[[0,1,0,6],[0,8,0,10],[0,13,0,14],[0,17,0,18],[0,21,0,22],[1,9,1,10],[1,21,1,22],[2,0,3,22],[4,3,8,3],[4,4,8,4],[4,5,8,5],[4,6,8,6],[4,7,8,7],[4,8,8,8],[4,9,8,9],[4,10,8,10],[4,11,8,11],[4,12,8,12],[4,13,8,13],[4,14,8,14],[4,15,8,15],[4,16,8,16],[118,1,118,2],[94,1,94,2],[95,1,95,2],[97,1,97,2],[98,1,98,2],[119,1,119,2],[121,1,121,2],[122,1,122,2],[129,1,129,2],[99,1,99,2],[100,1,100,2],[102,1,102,2],[103,1,103,2],[115,1,115,2],[157,1,157,3],[157,6,157,7],[158,1,158,3],[158,6,158,7],[123,1,123,2],[124,1,124,2],[126,1,126,2],[127,1,127,2],[140,1,140,2],[142,1,142,2],[130,1,130,2],[131,1,131,2],[144,1,145,2],[144,3,145,4],[155,1,155,7],[156,1,156,3],[132,1,132,2],[133,1,133,2],[134,1,134,2],[135,1,135,2],[136,1,136,2],[138,1,138,2],[82,1,82,2],[83,1,83,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[90,1,90,2],[91,1,91,2],[70,1,70,2],[71,1,71,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[78,1,78,2],[79,1,79,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[66,1,66,2],[67,1,67,2],[46,1,46,2],[47,1,47,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[54,1,54,2],[55,1,55,2],[23,1,23,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[30,1,30,2],[31,1,31,2],[58,1,58,2],[59,1,59,2],[10,1,10,2],[11,1,11,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[111,1,111,2],[112,1,112,2],[114,1,114,2],[18,1,18,2],[19,1,19,2],[106,1,106,2],[107,1,107,2],[109,1,109,2],[110,1,110,2],[34,1,34,2],[35,1,35,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[42,1,42,2],[43,1,43,2],[22,1,22,2]]}
["PROJECT DESCRIPTION:",null,null,null,null,null,null,"FIRM:",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C88","v":0},null,null,null,"TASK ORDER NUMBER:",null,null,null,"WBS NUMBER:",null,null,null,"DATE PREPARED:"]
["PREPARED BY: ",null,null,null,null,null,null,null,"TIP NUMBER:",null,null,null,null,null,null,null,null,null,null,null,"REVISION DATE:"]
["ENVIRONMENTAL BREAKDOWN WORKSHEET"]
[]
[null,null,null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C89","v":"CLASSIFICATION 1"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C90","v":"CLASSIFICATION 2"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C91","v":"CLASSIFICATION 3"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C92","v":"CLASSIFICATION 4"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C93","v":"CLASSIFICATION 5"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C94","v":"CLASSIFICATION 6"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C95","v":"CLASSIFICATION 7"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C96","v":"CLASSIFICATION 8"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C97","v":"CLASSIFICATION 9"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C98","v":"CLASSIFICATION 10"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C99","v":"CLASSIFICATION 11"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C100","v":"CLASSIFICATION 12"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C101","v":"CLASSIFICATION 13"},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!C102","v":"CLASSIFICATION 14"},"ROADWAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESIGN","HYDRAULIC","SUB-","%","PEF","%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRANCH","BRANCH","TOTAL","OF","ESTIMATE","OF"]
["TASK","TASK DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLENDED","BLENDED",null,"PROJECT",null,"PROJECT"]
["NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RATE","RATE"]
[1,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D11:S11)","v":0},{"$f":"IF(T11>0,T11/$T$130,\"\")","v":""},null,{"$f":"IF(V11>0,V11/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[2,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D23:S23)","v":0},{"$f":"IF(T23>0,T23/$T$130,\"\")","v":""},null,{"$f":"IF(V23>0,V23/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:S30)","v":0},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D31:S31)","v":0},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D32:S32)","v":0},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[3,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D35:S35)","v":0},{"$f":"IF(T35>0,T35/$T$130,\"\")","v":""},null,{"$f":"IF(V35>0,V35/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[4,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:S47)","v":0},{"$f":"IF(T47>0,T47/$T$130,\"\")","v":""},null,{"$f":"IF(V47>0,V47/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[5,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D59:S59)","v":0},{"$f":"IF(T59>0,T59/$T$130,\"\")","v":""},null,{"$f":"IF(V59>0,V59/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[6,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D71:S71)","v":0},{"$f":"IF(T71>0,T71/$T$130,\"\")","v":""},null,{"$f":"IF(V71>0,V71/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[7,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D83:S83)","v":0},{"$f":"IF(T83>0,T83/$T$130,\"\")","v":""},null,{"$f":"IF(V83>0,V83/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[8,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D95:S95)","v":0},{"$f":"IF(T95>0,T95/$T$130,\"\")","v":""},null,{"$f":"IF(V95>0,V95/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[9,"TASK NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D107:S107)","v":0},{"$f":"IF(T107>0,T107/$T$130,\"\")","v":""},null,{"$f":"IF(V107>0,V107/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[10,"MISCELLANEOUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D119:S119)","v":0},{"$f":"IF(T119>0,T119/$T$130,\"\")","v":""},null,{"$f":"IF(V119>0,V119/$V$130,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,"TOTAL WORKDAYS/CATEGORY:",null,{"$f":"SUM(D11:D129)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D130:S130)","v":0},{"$f":"SUM(U11:U96)","v":0},0,{"$f":"SUM(W11:W96)","v":0}]
[null,"EMPLOYEE NAME:",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D89","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D90","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D91","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D92","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D93","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D94","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D95","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D96","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D97","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D98","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D99","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D100","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D101","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!D102","v":0}]
[null,"HOURLY SALARY RATE:",null,{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E89","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E90","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E91","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E92","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E93","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E94","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E95","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E96","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E97","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E98","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E99","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E100","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E101","v":0},{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!E102","v":0}]
[null,"RATES PER DAY:",null,{"$f":"D132*8","v":0},{"$f":"E132*8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PAYROLL BURDEN:",null,{"$f":"SUM(D130*D133)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL WORKDAYS:",null,{"$f":"SUM(D130:S130)","v":0}]
[null,"TOTAL PAYROLL BURDEN:",null,{"$f":"SUM(D134:S134)","v":0}]
[null,"AVERAGE COST PER HOUR:",null,{"$f":"IF(D135<>0,SUM(D136/D135)/8,0)","v":0}]
[null,"GENERAL OVERHEAD (AS A PERCENTAGE xxx.xx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!F88","v":0},{"$f":"SUM(D136*C138)","v":0}]
[null,"SUBTOTAL:",null,{"$f":"SUM(D136+D138)","v":0}]
[null,"COMPARATIVE FEE @",0.09,{"$f":"SUM(D139*C140)","v":0}]
[null,"TOTAL:",null,{"$f":"SUM(D139:D140)","v":0}]
[null,null,"DIRECT EXPENSES @",{"$f":"H231","v":0}]
[null,"SUBCONSULTANT FEES:",null,0]
[null,"FACILITIES COST OF CAPITAL (AS A PERCENTAGE x.xxxx%)",{"$f":"'LIBRP_PEF CLASSIFICATION SHEET'!G88","v":0},{"$f":"D136*C144","v":0}]
[null,"TOTAL:",null,{"$f":"SUM(D141:D144)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["DIRECT EXPENSES"]
[]
["PROJECT\nDESCRIPTION: "]
["PREPARED BY:"]
["TIP NUMBER: ",null,null,null,"PROJECT NUMBER: "]
["DATE PREPARED:  ",null,null,null,"REVIEWED BY UNIT HEAD ON:"]
[]
[null,"Travel:"]
[null,"Sedan",0,"Trip(s) @",0,"miles @",{"$f":"SEDAN","v":0.67},{"$f":"SUM(C162*E162*G162)","v":0}]
[null,"Carry All",0,"Trip(s) @",0,"miles @",{"$f":"CARRYALL","v":0.69499999999999995},{"$f":"SUM(C163*E163*G163)","v":0}]
[null,"Car Rental",null,null,0,"days @ ",{"$f":"CARRENTAL","v":50},{"$f":"SUM(E164*G164)","v":0}]
[null,"Gas for Rental",null,null,0,"miles @",{"$f":"GASforRENTAL","v":0.2},{"$f":"E165*G165","v":0}]
[null,"Parking:",null,"Trip(s) @",null,null,{"$f":"PARKING","v":3},{"$f":"SUM(C166*G166)","v":0}]
[null,"Per Diem:",0,"Breakfast",null,null,{"$f":"BREAKFAST","v":10.1},0]
[null,null,0,"Lunch",null,null,{"$f":"LUNCH","v":13.3},0]
[null,null,0,"Dinner",null,null,{"$f":"DINNER","v":23.1},0]
[null,null,0,"Lodging (Including taxes)",null,null,{"$f":"LODGING_LUMP.SUM","v":95},0]
[null,"Reproduction:",0,"8 1/2 x 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},0]
[null,null,0,"11 x 17 Copy (s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},0]
[null,null,0,"Cover(s) @",null,null,{"$f":"COVERS","v":0.5},0]
[null,null,0,"Binder(s) @",null,null,{"$f":"BINDERS","v":0.5},0]
[null,null,0,"Color Copy(s) @",null,null,{"$f":"LETTERCOLOR","v":0.83},0]
[null,null,0,"Blueline(s) @",null,null,{"$f":"BLUEPRINTSLETTER","v":0.35},0]
[null,"Film and Developing:",0,"Roll(s) @",null,null,{"$f":"FILM","v":20},0]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H161:H177)","v":0}]
[]
[null,"Maps & Documents:"]
[null,"County Tax Maps:",0,"Map(s) @",null,null,{"$f":"County_Tax_Maps","v":7},{"$f":"SUM(C181*G181)","v":0}]
[null,"USGS Maps:",0,"Map(s) @",null,null,{"$f":"USGSMAPS","v":7},{"$f":"SUM(C182*G182)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H181:H182)","v":0}]
[]
[null,"Technical Reports"]
[null,"Reproduction:",0,"8 1/2 X 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C186*G186)","v":0}]
[null,null,0,"11 x 17 Copy(s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},{"$f":"SUM(C187*G187)","v":0}]
[null,null,0,"Blueline(s) @",null,null,{"$f":"BLUEPRINTSLETTER","v":0.35},{"$f":"SUM(C188*G188)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H186:H188)","v":0}]
[]
[null,"Design"]
[null,"Reproduction:",0,"8 1/2 x 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C192*G192)","v":0}]
[null,null,0,"11 x 17 Copy(s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},0]
[null,null,0,"Blueline(s) @",null,null,{"$f":"BLUEPRINTSLETTER","v":0.35},0]
[null,null,0,"Mylar Sepia(s) @",null,null,{"$f":"MYLARSLETTER","v":7.32},0]
[null,null,0,"Cross-Sections Sheet(s)",null,null,{"$f":"BOND.LARGE","v":3.5},0]
[null,null,0,"Enlarge Quad Map(s)",null,null,50,0]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H192:H197)","v":0}]
[]
[null,"Environmental Document"]
[null,"Reproduction:",0,"8 1/2 x 11 Copy(s) @",null,null,{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C201*G201)","v":0}]
[null,null,0,"11 x 17 Copy(s) @",null,null,{"$f":"LEDGERCOPIES","v":0.34},{"$f":"SUM(C202*G202)","v":0}]
[" ",null,0,"Cover(s) @",null,null,{"$f":"COVERS","v":0.5},{"$f":"SUM(C203*G203)","v":0}]
[null,null,0,"Binder(s) @",null,null,{"$f":"BINDERS","v":0.5},{"$f":"SUM(C204*G204)","v":0}]
[null,null,0,"Color Copy(s) @",null,null,{"$f":"LETTERCOLOR","v":0.83},{"$f":"SUM(C205*G205)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H201:H205)","v":0}]
[]
[null,"MEETINGS & PUBLIC INVOLVEMENT"]
[null,"Travel:"]
[null,"Sedan",0,"Trip(s) @",0,"miles @",{"$f":"SEDAN","v":0.67},{"$f":"SUM(C210*E210*G210)","v":0}]
[null,"CarryAll",0,"Trip(s) @",0,"miles @",{"$f":"CARRYALL","v":0.69499999999999995},{"$f":"SUM(C211*E211*G211)","v":0}]
[null,"Car Rental",null,null,0,"days @",{"$f":"CARRENTAL","v":50},{"$f":"SUM(E212*G212)","v":0}]
[null,"Gas for Rental",null,null,0,"miles @",{"$f":"GASforRENTAL","v":0.2},{"$f":"SUM(E213*G213)","v":0}]
[null,"Parking:",0,"Trip(s) @",null,null,{"$f":"PARKING","v":3},{"$f":"SUM(C214*G214)","v":0}]
[null,"Per Diem:",0,"Breakfast",null,null,{"$f":"BREAKFAST","v":10.1},{"$f":"SUM(C215*G215)","v":0}]
[null,null,0,"Lunch",null,null,{"$f":"LUNCH","v":13.3},{"$f":"SUM(C216*G216)","v":0}]
[null,null,0,"Dinner",null,null,{"$f":"DINNER","v":23.1},{"$f":"SUM(C217*G217)","v":0}]
[null,null,0,"Lodging (Including taxes)",null,null,{"$f":"LODGING_LUMP.SUM","v":95},{"$f":"SUM(C218*G218)","v":0}]
[null,"Workshop Handouts"]
[null,"  - Reproduction",0,"8 1/2 x 11 Page(s) @",0,"Handouts",{"$f":"LETTERCOPIES","v":0.14000000000000001},{"$f":"SUM(C220*G220)","v":0}]
[null,null,0,"11 x 17 Page(s) @",0,"Handouts",{"$f":"LEDGERCOPIES","v":0.34},{"$f":"SUM(C221*E221*G221)","v":0}]
[null,"Presentation Materials:"]
[null,"  - Public Officials Meetings:",0,"Meeting(s) @",null,null,50,{"$f":"SUM(C223*G223)","v":0}]
[null,"  - Public Workshops:",0,"Workshop(s) @",null,null,200,{"$f":"SUM(C224*G224)","v":0}]
[null,"  - Slide Presentation:",0,"Presentation @",null,null,350,{"$f":"SUM(C225*G225)","v":0}]
[null,"Mailing Labels:",0,"Box(s) @",null,null,37,{"$f":"SUM(C226*G226)","v":0}]
[null,"Postage:"]
[null,"  - Public Workshops:",0,"Workshop(s) @",0,"copies @",{"$f":"POSTAGE","v":0.49},{"$f":"SUM(C228*E228*G228)","v":0}]
[null,null,null,null,null,"Subtotal",null,{"$f":"SUM(H209:H228)","v":0}]
[]
[null,null,null,null,null,"TOTAL",null,{"$f":"SUM(H178+H183+H189+H198+H206+H229)","v":0}]

{"sheet":"Version Info","index":16,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"  Version 4.1                     02/14/97"]
[null,null,null,"Added English Bridge Replacement page"]
[]
[null,null,"  Version 4                       02/14/97"]
[null,null,null,"Revised formulae on Output page"]
[]
[null,null,"  Version 3.42                   02/12/97"]
[null,null,null,"Updated maximum escalation"]
[]
[null,null,"  Version 3.41                   02/04/97"]
[null,null,null,"Minor formula adjustments"]
[]
[null,null,"  Version 3.4                    01/09/97"]
[null,null,null,"Added Bridge Replacement page"]
[]
[null,null,"  Version 3.31                   01/07/97"]
[null,null,null,"Minor formula adjustments"]
[]
[null,null,"  Version 3.3                    10/30/96"]
[null,null,null,"Changed item order to reflect new forms"]
[null,null,null,"Added Subconsultant blank to input form"]
[]
[null,null,"  Version 3.2                    01/18/96"]
[null,null,null,"Updated maximum overhead"]
[null,null,null,"Added escalation option"]
[]
[null,null,"  Version 3.1                    01/17/96"]
[null,null,null,"Added cost of capital option"]
[]
[null,null,"  Version 3.0"]
[null,null,null,"Converted from Lotus 1-2-3 to MS Excel."]
[null,null,null,"Created a formal input form."]
[null,null,null,"Updated reproduction costs to reflect changed paper requirements."]
[]
[null,null,"  Version 2.0"]
[null,null,null,"Converted from English to Metric Units."]
[]
[null,null,"  Version 1.0"]
[null,null,null,"Original version created in Lotus 1-2-3."]